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