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