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