1019_hws

Tables (4)

category (Untitled3)

  • Key — Primary key — NOT NULL
  • name (Field) — text

products (Untitled2)

  • Key — Primary key — NOT NULL
  • category_code (Key3) — Foreign key → category.Key — NOT NULL
  • code (Field) — text
  • price (Field2) — text
  • end_date (Field3) — date

sale (Untitled4)

  • Key — Primary key — NOT NULL
  • store_id (Key2) — text — Foreign key → stores.Key — NOT NULL
  • product_code (Key3) — text — Foreign key → products.Key — NOT NULL

stores (Untitled)

  • Key — Primary key — NOT NULL
  • name (Field) — text
  • address_si (Field2) — text
  • address_gu (Field3) — text
  • address_dong (Field4) — text
  • phone_number (Field5) — text