convenience store

Tables (7)

Beverage (local(지역))

  • pk (local_pk) — NOT NULL — Primary key — NOT NULL
  • name — NULL

Untitled (product(제품))

  • Key (product_pk) — NOT NULL — Primary key — NOT NULL
  • Field (name) — NULL
  • Field2 (price) — NULL
  • Field3 (expiration date) — NULL
  • Key (PG_pk) — NOT NULL — Foreign key → Untitled.Key — NOT NULL

Untitled (company(제조사))

  • Key (company_pk) — NOT NULL — Primary key — NOT NULL
  • Field (name) — NULL
  • Field (asset) — NULL
  • Key (product_pk) — NOT NULL — Foreign key → Untitled.Key — NOT NULL

Untitled (Subcontractor(납품회사))

  • Key (Subcontractor_pk) — NOT NULL — Primary key — NOT NULL
  • Field (material) — NULL
  • Key (company_pk) — NOT NULL — Foreign key → Untitled.Key — NOT NULL

Untitled (overseas (해외지사))

  • Key (overseas_pk) — NOT NULL — Primary key — NOT NULL
  • Field (location) — NULL
  • Key (company_pk) — NOT NULL — Foreign key → Untitled.Key — NOT NULL

Untitled (제품분류 (Product Group))

  • Key (PG_pk) — NOT NULL — Primary key — NOT NULL
  • Field (과자) — NULL
  • Field2 (담배) — NULL
  • Field (아이스크림) — NULL
  • Field (냉동) — NULL
  • pk (branch_pk) — NOT NULL — Foreign key → ingredient.pk — NOT NULL

ingredient (branch(지점))

  • pk (branch_pk) — NOT NULL — Primary key — NOT NULL
  • name — NULL
  • Field (main street) — NULL
  • pk (local_pk) — NOT NULL — Foreign key → Beverage.pk — NOT NULL