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