convenience store

Tables (3)

Product

  • Product (product) — NOT NULL — Primary key — NOT NULL
  • Info (info) — NOT NULL — Foreign key → Store.Info — NOT NULL
  • household goods — NULL — NOT NULL
  • Snacks (snacks) — NULL
  • Foods (foods) — NULL
  • Drinks (drinks) — NULL
  • Noodles (noodles) — NULL — NOT NULL

Region

  • Region (region) — NOT NULL — Primary key — NOT NULL
  • Field — NOT NULL

Store (store)

  • Info (info) — NOT NULL — Primary key — NOT NULL
  • Region (region) — NOT NULL — Foreign key → Region.Region — NOT NULL
  • Store_name (name) — NOT NULL
  • Store_address (address) — NOT NULL
  • Store_open (open) — NOT NULL
  • Store_close (close) — NOT NULL
  • Store_number (number) — NULL