Contact_Order_Brand_ERD
Tables (3)
Brand
- brandCode (Key) — varchar(100) — Primary key — NOT NULL
- brandNameKR — varchar(100)
- brandGroup — varchar(100)
contact
- contactId (Key) — varchar(100) — Primary key — NOT NULL
order
- orderId — varchar(100) — Primary key — NOT NULL
- orderDate — date
- contactId (Key) — varchar(100) — Foreign key → contact.contactId — NOT NULL
- brandCode (Key2) — varchar(100) — Foreign key → Brand.brandCode — NOT NULL