aqcontract

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
contractnumber INT 10 √ null
aqbasket.contractnumber aqbasket_ibfk_2 R
contractstartdate DATE 10 √ null
contractenddate DATE 10 √ null
contractname VARCHAR 50 √ null
contractdescription LONGTEXT 2147483647 √ null
booksellerid INT 10 null
aqbooksellers.id booksellerid_fk1 C

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc contractnumber
booksellerid_fk1 Performance Asc booksellerid

Relationships

Close relationships within degrees of separation