Table: agentTable: affiliation

Select data Show structure Alter table New item

Column Type Comment

aff$\_$id integer

title character varying$(20)$ NULL

description character varying$(50)$ NULL

Indexes

PRIMARY aff$\_$id

Alter indexes

Foreign keys

Add foreign key

Triggers

Add trigger

Select data Show structure Alter table New item

Column Type Comment

agent$\_$id integer

first character varying$(20)$ NULL

middle character varying$(20)$ NULL

last character varying$(20)$ NULL

address character varying$(50)$ NULL

city character varying$(20)$ NULL

country character varying$(20)$ NULL

salary integer NULL

clearance$\_$id integer NULL

Indexes

PRIMARY agent$\_$id

Alter indexes

Foreign keys

Source Target ON DELETE ON UPDATE

clearance$\_$id securityclearance$($sc$\_$id$)$ NO ACTION NO ACTION Alter

Add foreign key

Triggers

Add trigge