Table missions


Physical Name:
missions

Constraint:



Attribute Summary
PK FK Logical Name Physical Name Type UNIQUE NOT NULL
    id  id  varchar(20)    NOT NULL 
    description  description  varchar(50)    NOT NULL 
    enddate  enddate  date     
    startdate  startdate  date    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
id  vehicles  mission_fk  NO ACTION  NO ACTION  0..1  1..n 

Complex Unique Key
 

Index Summary
Index Name Type UNIQUE

Attribute Detail

id

id


	

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


description

description


	

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


enddate

enddate


	

UNIQUE : FALSE
NOT NULL : FALSE
Type : date
AUTO INCREMENT : FALSE
Default Value :
Constraint :


startdate

startdate


	

UNIQUE : FALSE
NOT NULL : TRUE
Type : date
AUTO INCREMENT : FALSE
Default Value :
Constraint :