aesports

테이블 (16)

account

  • id — binary(16) — NOT NULL
  • email — varchar(255) — NOT NULL
  • password — varchar(255) — NOT NULL
  • provider_type — enum — NOT NULL
  • role_type — enum — NOT NULL
  • created_datetime — datetime(6) — NOT NULL
  • updated_datetime — datetime(6) — NOT NULL

certification

  • id — bigint — NOT NULL
  • account_id — binary(16) — NOT NULL
  • name — varchar(255) — NOT NULL
  • phone_number — varchar(255) — NOT NULL
  • certification_no — varchar(255) — NOT NULL
  • created_datetime — datetime(6) — NOT NULL

club

  • id — bigint — NOT NULL
  • realm_id — binary(16) — NOT NULL
  • owner_id — bigint — NOT NULL
  • name — varchar(255) — NOT NULL
  • description — text — NOT NULL
  • club_plans_id — int — NOT NULL
  • is_active — tinyint(1) — NOT NULL
  • created_datetime — datetime(6) — NOT NULL
  • updated_datetime — datetime(6) — NOT NULL

club_member

  • id — bigint — NOT NULL
  • club_id — bigint — NOT NULL
  • user_id — bigint — NOT NULL
  • club_role_type — enum — NOT NULL
  • created_datetime — datetime(6) — NOT NULL
  • updated_datetime — datetime(6) — NOT NULL
  • is_deleted — tinyint(1) — NOT NULL

club_plans

  • id — int — NOT NULL
  • realm_id — binary(16) — NOT NULL
  • name — varchar(255) — NOT NULL
  • price — bigint — NOT NULL
  • period — int — NOT NULL
  • created_datetime — datetime(6) — NOT NULL

club_subscriptions

  • id — bigint — NOT NULL
  • club_id — bigint — NOT NULL
  • club_plans_id — int — NOT NULL
  • start_datetime — datetime(6) — NOT NULL
  • end_datetime — datetime(6) — NOT NULL

game_account

  • id — bigint — NOT NULL
  • realm_id — binary(16) — NOT NULL
  • user_id — bigint — NOT NULL
  • nickname — varchar(255) — NOT NULL
  • created_datetime — datetime(6) — NOT NULL

realm

  • realm_id — bigint — 기본 키 — NOT NULL
  • game — enum — NOT NULL
  • description — varchar(255)
  • created_datetime — datetime(6) — NOT NULL
  • updated_datetime — datetime(6) — NOT NULL

team

  • id — bigint — NOT NULL
  • realm_id — binary(16) — NOT NULL
  • club_id — bigint — NOT NULL
  • name — varchar(255) — NOT NULL
  • team_size — int — NOT NULL
  • created_datetime — datetime(6) — NOT NULL
  • updated_datetime — datetime(6) — NOT NULL

team_member

  • id — bigint — NOT NULL
  • team_id — bigint — NOT NULL
  • user_id — bigint — NOT NULL
  • team_role_type — enum — NOT NULL
  • created_datetime — datetime(6) — NOT NULL
  • updated_datetime — datetime(6) — NOT NULL

user

  • user_id — bigint — 기본 키 — NOT NULL
  • account_id — binary(16) — NOT NULL
  • realm_id — binary(16) — NOT NULL
  • nickname — varchar(255) — NOT NULL

댓글 (comment)

  • comment_id — bigint — 기본 키 — NOT NULL
  • 내용 (content) — text — NOT NULL
  • created_datetime — datetime(6) — NOT NULL
  • updated_datetime — datetime(6) — NOT NULL
  • community_id — bigint — 외래 키 → 커뮤니티 글.community_post_id — NOT NULL
  • user_id (user_id2) — bigint — 외래 키 → user.user_id — NOT NULL

좋아요 (board_like)

  • like_id — bigint — 기본 키 — NOT NULL
  • created_datetime — datetime(6) — NOT NULL
  • updated_datetime — datetime(6) — NOT NULL
  • community_id — bigint — 외래 키 → 커뮤니티 글.community_post_id — NOT NULL
  • user_id (user_id2) — bigint — 외래 키 → user.user_id — NOT NULL

커뮤니티 게시판(미사용) (community_board)

  • community_board_id (community_borad_id) — bigint — 기본 키 — NOT NULL
  • 게시판명 (name) — varchar(255) — NOT NULL
  • 설명 (description) — varchar(255) — NOT NULL
  • 게시판 상태 (status) — enum — NOT NULL — 사용, 미사용
  • 읽기 권한 (read_role) — enum — NOT NULL — ALL, LOGIN_USER, ADMIN
  • 쓰기 권한 (write_role) — enum — NOT NULL — ALL, LOGIN_USER, ADMIN
  • 댓글 권한 (comment_role) — enum — NOT NULL — ALL, LOGIN_USER_ADMIN
  • 댓글 사용 여부 (comment_usage) — tinyint(1) — NOT NULL
  • 생성일 (created_date) — date — NOT NULL
  • 삭제 여부 (is_deleted) — tinyint(1) — NOT NULL
  • created_datetime — datetime(6) — NOT NULL
  • updated_datetime — datetime(6) — NOT NULL

커뮤니티 글 (community_post)

  • community_post_id — bigint — 기본 키 — NOT NULL
  • 제목 (title) — varchar(255) — NOT NULL
  • 내용 (content) — text — NOT NULL
  • 카테고리 (category) — varchar — NOT NULL — enum
  • 커뮤니티 글 상태 (status) — varchar — NOT NULL — enum(정상, 신고, 블라인드)
  • 조회수 (view_count) — int — NOT NULL
  • 좋아요 수 (like_count) — int — NOT NULL
  • 작성일 (created_date) — date — NOT NULL
  • is_deleted — tinyint(1) — NOT NULL
  • created_datetime — datetime(6) — NOT NULL
  • updated_datetime — datetime(6) — NOT NULL
  • user_id — bigint — 외래 키 → user.user_id — NOT NULL
  • realm_id (realm_id2) — bigint — 외래 키 → realm.realm_id — NOT NULL

커뮤니티 파일 (community_file)

  • file_id — bigint — 기본 키 — NOT NULL
  • file_url — VARCHAR — NOT NULL
  • 파일 이름 (file_name) — VARCHAR — NOT NULL
  • 임시 파일 여부 (temporary) — tinyint(1) — NOT NULL — default = true
  • 업로드 일시 (uploaded_at) — datetime(6) — NOT NULL
  • community_post_id — bigint — 외래 키 → 커뮤니티 글.community_post_id — NOT NULL