Table roles


Physical Name:
roles

Constraint:



Attribute Summary
PK FK Logical Name Physical Name Type UNIQUE NOT NULL
    role  role  varchar(5)    NOT NULL 
    description  description  varchar(255)    NOT NULL 

Foreign Key
Attribute Referenced Table Referenced Key ON UPDATE ON DELETE Cardinality of parent Cardinality of child

Referenced Key
Attribute Table Foreign Key ON UPDATE ON DELETE Cardinality of parent Cardinality of child
role  users  role_fk  NO ACTION  NO ACTION  1..n 

Complex Unique Key
 

Index Summary
Index Name Type UNIQUE

Attribute Detail

role

role


	

UNIQUE : FALSE
NOT NULL : TRUE
Type : varchar(5)
AUTO INCREMENT : FALSE
Default Value :
Constraint :


description

description


	

UNIQUE : FALSE
NOT NULL : TRUE
Type : varchar(255)
AUTO INCREMENT : FALSE
Default Value :
Constraint :