BE5-1

Tables (11)

Chat_Message

  • message_id — BIGINT
  • chat_room_id — BIGINT — NOT NULL
  • sender_id — BIGINT — NOT NULL
  • message_content — TEXT — NOT NULL
  • sent_at — TIMESTAMP

Chat_Participant

  • chat_part_id — BIGINT
  • chat_room_id — BIGINT — NOT NULL
  • user_id — BIGINT — NOT NULL
  • joined_at — TIMESTAMP

Chat_Room

  • chat_room_id — BIGINT
  • room_type — ENUM('1대1', '그룹', '전체') — NOT NULL
  • room_id — BIGINT
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

Match_Participant

  • participant_id — BIGINT
  • room_id — BIGINT — NOT NULL
  • user_id — BIGINT — NOT NULL
  • status — ENUM('대기', '승인', '거절')
  • joined_at — TIMESTAMP

Match_Room

  • room_id — BIGINT
  • stadium_id — BIGINT — NOT NULL
  • host_id — BIGINT — NOT NULL
  • match_date — DATE — NOT NULL
  • match_time — TIME — NOT NULL
  • max_players — INT — NOT NULL
  • current_players — INT
  • level — ENUM('초급', '중급', '고급') — NOT NULL
  • status — ENUM('모집중', '모집완료', '경기완료', '취소')
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

Notification

  • notification_id — BIGINT
  • user_id — BIGINT — NOT NULL
  • content — VARCHAR(255) — NOT NULL
  • is_read — BOOLEAN
  • created_at — TIMESTAMP

Post

  • post_id — BIGINT
  • user_id — BIGINT — NOT NULL
  • category — ENUM('공지', '자유게시판', '팁과모임', '리뷰') — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • content — TEXT — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

Review

  • review_id — BIGINT
  • stadium_id — BIGINT — NOT NULL
  • user_id — BIGINT — NOT NULL
  • rating — INT — NOT NULL
  • content — TEXT
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

Schedule

  • schedule_id — BIGINT
  • user_id — BIGINT — NOT NULL
  • room_id — BIGINT — NOT NULL
  • match_date — DATE — NOT NULL
  • match_time — TIME — NOT NULL
  • created_at — TIMESTAMP

Stadium

  • stadium_id — BIGINT
  • name — VARCHAR(100) — NOT NULL
  • address — VARCHAR(255) — NOT NULL
  • latitude — DECIMAL(10, 8)
  • longitude — DECIMAL(11, 8)
  • phone — VARCHAR(20)
  • facility_info — TEXT
  • price — VARCHAR(100)
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

User

  • user_id — BIGINT
  • username — VARCHAR(50) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • nickname — VARCHAR(50) — NOT NULL
  • profile_image — VARCHAR(255)
  • address — VARCHAR(255)
  • activity_score — INT
  • level — ENUM('초급', '중급', '고급') — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP