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