0929 workshop

Tables (3)

Store (Untitled2)

  • Store_name — TEXT — Primary key — NOT NULL
  • place — TEXT
  • owner — TEXT

owner (Untitled3)

  • name — TEXT
  • age — INTEGER
  • Store_name — TEXT — Foreign key → Store.Store_name — NOT NULL

product (Untitled)

  • type — TEXT
  • price — INTEGER
  • created_date — DATE
  • Store_name (store_name) — TEXT — Foreign key → Store.Store_name — NOT NULL