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