1021_homework
Tables (3)
Category (카테고리)
- category_id (Key) — int — Primary key — NOT NULL
- convenience_id (Key2) — int — Foreign key → Convenience.convenience_id — NOT NULL
- product_id (Key3) — int — Foreign key → Product.product_id — NOT NULL
Convenience (편의점)
- convenience_id (Key) — int — Primary key — NOT NULL
- location (Field) — varcher(50)
- name (Field2) — varchar(30)
Product (상품)
- product_id (Key) — int — Primary key — NOT NULL
- name (Field) — varchar(50)
- price (Field2) — int