|
||||||
PREV Table NEXT Table | FRAMES NO FRAMES |
Attribute Summary | ||||||
---|---|---|---|---|---|---|
PK | FK | Logical Name | Physical Name | Type | UNIQUE | NOT NULL |
![]() |
logname | logname | varchar(12) | NOT NULL | ||
varchar(320) | NOT NULL | |||||
name | name | varchar(30) | NOT NULL | |||
password | password | varchar(44) | NOT NULL | |||
phone | phone | varchar(19) | NOT NULL | |||
surname | surname | varchar(40) | NOT NULL | |||
![]() |
role_fk | role_fk | varchar(5) | NOT NULL |
Foreign Key | ||||||
---|---|---|---|---|---|---|
Attribute | Referenced Table | Referenced Key | ON UPDATE | ON DELETE | Cardinality of parent | Cardinality of child |
role_fk | roles | role | NO ACTION | NO ACTION | 1 | 1..n |
Referenced Key | ||||||
---|---|---|---|---|---|---|
Attribute | Table | Foreign Key | ON UPDATE | ON DELETE | Cardinality of parent | Cardinality of child |
Complex Unique Key |
---|
Index Summary | ||
---|---|---|
Index Name | Type | UNIQUE |
Attribute Detail |
---|
|
||||||
PREV Table NEXT Table | FRAMES NO FRAMES |