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