buy-now

Tables (4)

item (CopyOfmember)

  • id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(60)
  • price (Field4) — BIGINT
  • sale_price (Field5) — BIGINT
  • stock (Field) — INT
  • start_date (Field2) — DATETIME
  • end_date (Field3) — DATETIME

member

  • id — BIGINT — Primary key — NOT NULL
  • login_id — VARCHAR(45)
  • password — VARCHAR(45)
  • name — VARCHAR(45)
  • telephone_number (Field4) — VARCHAR(45)
  • address (Field5) — VARCHAR(60)
  • address_detail (Field) — VARCHAR(60)
  • join_date (Field2) — DATETIME
  • last_updated_date (Field3) — DATETIME
  • admin_yn (Field6) — TINYINT(1)

order_item (CopyOfCopyOfmember)

  • order_id (Key) — BIGINT — Foreign key → orders.id — NOT NULL
  • item_id (id) — BIGINT — Foreign key → item.id — NOT NULL
  • quantity (Field) — INT
  • price (Field4) — BIGINT

orders (Untitled)

  • id (Key) — BIGINT — Primary key — NOT NULL
  • user_id (id) — BIGINT — Foreign key → member.id — NOT NULL
  • order_no (Field2) — VARCHAR(45)
  • name (Field3) — VARCHAR(45)
  • telephone_number (Field4) — VARCHAR(45)
  • address (Field5) — VARCHAR(60)
  • address_detail (Field6) — VARCHAR(60)
  • order_date (Field7) — DATETIME
  • status (Field8) — VARCHAR(10)
  • cancel_date (Field9) — DATETIME