conve

Tables (3)

Category (category)

  • Conve_id (conve_id) — INT(100) — Foreign key → GS50.Conve_id — NOT NULL
  • Content_id (content_id) — INT(100) — Foreign key → Content.Content_id — NOT NULL

Content (content)

  • Content_id (content_id) — INT(100) — Primary key — NOT NULL
  • Content_name (content_name) — VARCHAR(250)
  • Price (price) — INT(10)
  • Arrival_date (arrival_date) — INT(8)
  • Expiration_date (expiration_date) — INT(8)
  • Manufacturer (manufacturer) — VARCHAR(100)
  • Stock (stock) — INT(8)

GS50 (7&11)

  • Conve_id (conve_id) — INT(100) — Primary key — NOT NULL
  • City (city) — VARCHAR(100)
  • Store_name (store_name) — VARCHAR(250)
  • Phone (phone) — VARCHAR(11)