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