v1

Tables (7)

comment

  • id — bigint — Primary key — NOT NULL
  • schedule_id — bigint — NOT NULL
  • member_id — bigint — NOT NULL
  • contents — varchar(255) — NOT NULL
  • created_at — datetime — NOT NULL
  • modified_at — datetime — NOT NULL
  • id (id2) — bigint — Foreign key → member.id — NOT NULL

hotdeal

  • id — bigint — Primary key — NOT NULL
  • product_id — bigint — NOT NULL
  • start — datetime — NOT NULL
  • due — datetime — NOT NULL
  • id (id2) — bigint — Foreign key → product.id — NOT NULL

match_schedule

  • id — bigint — Primary key — NOT NULL
  • type — varchar(255) — NOT NULL
  • home — varchar(255) — NOT NULL
  • away — varchar(255) — NOT NULL
  • home_score — int — NOT NULL
  • away_score — int — NOT NULL
  • start_hour — datetime — NOT NULL
  • id (id2) — bigint — Foreign key → comment.id — NOT NULL

member

  • id — bigint — Primary key — NOT NULL
  • username — varchar(30) — NOT NULL
  • nickname — varchar(30) — NOT NULL
  • password — varchar(255) — NOT NULL
  • created_at — datetime — NOT NULL
  • role — enum — NOT NULL

order

  • id — bigint — Primary key — NOT NULL
  • member_id — bigint — NOT NULL
  • id2 — bigint — NOT NULL
  • total_price — int — NOT NULL
  • order_date — datetime — NOT NULL
  • address — varchar(255) — NOT NULL
  • phone — varchar(255) — NOT NULL
  • id (id3) — bigint — Foreign key → member.id — NOT NULL
  • id (id4) — bigint — Foreign key → product.id — NOT NULL

order_product

  • id — bigint — Primary key — NOT NULL
  • product_id — bigint — NOT NULL
  • id2 — bigint — NOT NULL
  • card_quantity — int
  • id (id3) — bigint — Foreign key → member.id — NOT NULL
  • id (id4) — bigint — Foreign key → product.id — NOT NULL

product

  • id — bigint — Primary key — NOT NULL
  • title — varchar(255) — NOT NULL
  • content — text — NOT NULL
  • image_url — varchar(255)
  • created_at — datetime — NOT NULL
  • modified_at — datetime — NOT NULL