LOLKET
Tables (13)
Banner (배너)
- unique_id (고유 번호) — text — Primary key — NOT NULL
- display_place (전시 위치) — DISPLAY_PLACE
- image (이미지) — image
- sort_num (정렬 순서) — number
- created_by (생성자) — User — Foreign key → User.unique_id — NOT NULL
Comment (댓글)
- unique_id (고유 번호) — text — Primary key — NOT NULL
- comment_type (댓글 유형) — COMMENT_tYPE
- contents (내용) — text
- community (커뮤니티) — Community — Foreign key → Community.unique_id — NOT NULL
- notice (공지사항) — Notice — Foreign key → Notice.unique_id — NOT NULL
- like_user_list (좋아요 유저 리스트) — List<User> — Foreign key → User.unique_id — NOT NULL
- root_comment (루트 댓글) — Comment — Foreign key → Comment.unique_id — NOT NULL
- parent_comment (부모 댓글) — Comment — Foreign key → Comment.unique_id — NOT NULL
- user (유저) — User — Foreign key → User.unique_id — NOT NULL
- writer (작성자) — User — Foreign key → User.unique_id — NOT NULL
Community (커뮤니티)
- unique_id (고유 번호) — text — Primary key — NOT NULL
- community_type (커뮤니티 유형) — COMMUNITY_TYPE
- title (제목) — text
- contents (내용) — text
- created_at (작성 일시) — Datetime
- user (작성자) — User — Foreign key → User.unique_id — NOT NULL
Event (이벤트)
- unique_id (고유 번호) — text — Primary key — NOT NULL
- event_type (이벤트 유형) — EVENT_TYPE
- title (제목) — text
- contents (내용) — textd
- start_at (시작 일시) — DateTime
- end_at (종료 일시) — DateTime
- writer (작성자) — User — Foreign key → User.unique_id — NOT NULL
Game (게임)
- unique_id (고유 번호) — text — Primary key — NOT NULL
- game_type (게임 유형) — GAME_TYPE
- game_status (게임 상태) — GAME_STATUS
- start_at (게임 시작 일시) — DateTime
- host_admin_list (주최 관리자 리스트) — List<User> — Foreign key → User.unique_id — NOT NULL
- created_at (생성 일시) — DateTime
GameUser (게임 참여 유저)
- unique_id (고유 번호) — text — Primary key — NOT NULL
- name (게임 아이디) — text
- is_sign_in (회원 여부) — boolean
- top_tier_type (탑 티어 유형) — TIER_TYPE
- cur_tier_type (현 티어 유형) — TIER_TYPE
- main_position (주 라인) — POSITION_tYPE
- sub_position (보조 라인) — POSITION_TYPE
- position (배정 라인) — POSITION_TYPE
- is_on (출석 여부) — boolean
- user (유저) — User — Foreign key → User.unique_id — NOT NULL
- game (게임) — Game — Foreign key → Game.unique_id — NOT NULL
- team (소속 팀) — Team — Foreign key → Team.unique_id — NOT NULL
- ========= — ========
- oction_point (낙찰가) — number
Match (매칭)
- unique_id (고유번호) — text — Primary key — NOT NULL
- created_at (생성 일시) — DateTime
- match_team_list (매칭 팀 리스트) — List<Team> — Foreign key → Team.unique_id — NOT NULL
- win_team (승리팀) — Team — Foreign key → Team.unique_id — NOT NULL
- defeat_team (패배팀) — Team — Foreign key → Team.unique_id — NOT NULL
- unique_id (고유 번호) — text — Foreign key → Game.unique_id — NOT NULL
MatchSet (매칭 세트)
- unique_id (고유 번호) — text — Primary key — NOT NULL
- created_at (생성 일시) — DateTime
- match (매칭) — Match — Foreign key → Match.unique_id — NOT NULL
- win_team (승리팀) — Team — Foreign key → Team.unique_id — NOT NULL
- defeat_team (패배팀) — Team — Foreign key → Team.unique_id — NOT NULL
Notice (공지사항)
- unique_id (고유 번호) — text — Primary key — NOT NULL
- is_important (중요 공지 여부) — boolean
- title (제목) — text
- contents (내용) — text
- created_at (작성 일시) — Dattime
- admin (작성 관리자) — User — Foreign key → User.unique_id — NOT NULL
Notification (알림)
- unique_id (고유 번호) — text — Primary key — NOT NULL
- notification_type (알림 유형) — NOTIFICATION_TYPE
- title (제목) — text
- contents (내용) — text
- is_view (열람 여부) — boolean
- user (유저) — User — Foreign key → User.unique_id — NOT NULL
Report (신고하기)
- unique_id (고유 번호) — text — Primary key — NOT NULL
- report_type (신고 사유) — REPORT_TYPE
- title (제목) — text
- contents (냐용)
- target_user (신고받은 유저) — User — Foreign key → User.unique_id — NOT NULL
- user (신고한 유저) — User — Foreign key → User.unique_id — NOT NULL
Team (팀)
- unique_id (고유 번호) — text — Primary key — NOT NULL
- name (팀 명) — text
- leader (팀장) — GameUser — Foreign key → GameUser.unique_id — NOT NULL
- member_list (멤버 리스트) — List<GameUser> — Foreign key → GameUser.unique_id — NOT NULL
- game (게임) — Game — Foreign key → Game.unique_id — NOT NULL
- ======= (======) — =====
- oction_rest_point (잔여 포인트) — number
User (유저)
- unique_id (고유 번호) — text — Primary key — NOT NULL
- user_type (유저 유형) — USER_TYPE
- user_state (유저 상태) — USER_STATE
- email (임의 이메일) — text
- id (아이디) — text
- password (패스워드) — text
- init_password (초기 패스워드) — text
- control_password (조작 패스워드) — text
- gender_type (성별 유형) — GENDER_TYPE
- title (칭호) — text
- name (유저명) — text
- birth_at (생년월일) — Datetime
- last_login_at (마지막 로그인 일시) — Datetime
- top_tier_type (탑 티어 유형) — TIER_TYPE
- cur_tier_type (현 티어 유형) — TIER_TYPE
- lol_id (롤 ID) — text
- tag (태그) — text