Play-Baseball
Tables (11)
exchange
- exchange_id — BIGINT — Primary key — NOT NULL
- member_id — BIGINT — Foreign key → member.member_id — NOT NULL
- title — VARCHAR(200) — NOT NULL
- price — INT — NOT NULL
- regular_price — INT — NOT NULL
- content — VARCHAR(255) — NOT NULL
- view_count — INT — NOT NULL
- status — ENUM('COMPLETE', 'SALE') — NOT NULL
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6)
- deleted_at — DATETIME(6)
- reviewed_at — DATETIME(6)
exchange_image
- exchange_image_id — BIGINT — Primary key — NOT NULL
- exchange_id — BIGINT — Foreign key → exchange.exchange_id — NOT NULL
- url — VARCHAR(255) — NOT NULL
- created_at — DATETIME(6) — NOT NULL
exchange_like
- like_id — BIGINT — Primary key — NOT NULL
- exchange_id — BIGINT — Foreign key → exchange.exchange_id — NOT NULL
- member_id — BIGINT — Foreign key → member.member_id — NOT NULL
- created_at — DATETIME(6) — NOT NULL
- canceled_at — DATETIME(6)
like_overview
- like_overview_id — BIGINT — Primary key — NOT NULL
- exchange_id — BIGINT — Foreign key → exchange.exchange_id — NOT NULL
- count — BIGINT — NOT NULL
member
- member_id — BIGINT — Primary key — NOT NULL
- email — VARCHAR(100) — NOT NULL
- password — VARCHAR(68) — NOT NULL
- nickname — VARCHAR(100) — NOT NULL
- name — VARCHAR(100) — NOT NULL
- phone_number — VARCHAR(20) — NOT NULL
- gender — ENUM('FEMALE', 'MALE', 'NON_BINARY') — NOT NULL
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6)
- deleted_at — DATETIME(6)
- last_login_date — DATETIME(6)
- email_verified — TINYINT(1) — NOT NULL
- otp_verified — TINYINT(1) — NOT NULL
- role — ENUM('USER', 'ADMIN', 'BANNED') — NOT NULL
message
- message_id — BIGINT — Primary key — NOT NULL
- member_id — BIGINT — Foreign key → member.member_id — NOT NULL
- message_room_id — BIGINT — Foreign key → message_room.message_room_id — NOT NULL
- message_content — TEXT — NOT NULL
- created_at — DATETIME(6) — NOT NULL
message_member
- message_member_id — BIGINT — Primary key — NOT NULL
- member_id — BIGINT — Foreign key → member.member_id — NOT NULL
- message_room_id — BIGINT — Foreign key → message_room.message_room_id — NOT NULL
- created_at — DATETIME(6) — NOT NULL
message_room
- message_room_id — BIGINT — Primary key — NOT NULL
- last_message_at — DATETIME(6)
- created_at — DATETIME(6) — NOT NULL
review
- review_id — BIGINT — Primary key — NOT NULL
- exchange_id — BIGINT — Foreign key → exchange.exchange_id — NOT NULL
- member_id — BIGINT — Foreign key → member.member_id — NOT NULL
- content — VARCHAR(300) — NOT NULL
- rate — INT — NOT NULL
- is_secret — BIT(1) — NOT NULL
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6)
- deleted_at — DATETIME(6)
review_image
- review_image_id — BIGINT — Primary key — NOT NULL
- review_id — BIGINT — Foreign key → review.review_id — NOT NULL
- url — VARCHAR(255) — NOT NULL
- created_at — DATETIME(6) — NOT NULL
review_overview
- review_overview_id — BIGINT — Primary key — NOT NULL
- member_id — BIGINT — Foreign key → member.member_id — NOT NULL
- count — BIGINT
- average — DOUBLE