durudurub
Tables (16)
banners
- no — INT — Primary key — NOT NULL — PK
- title — VARCHAR(100) — NOT NULL — 배너 제목
- image_url — VARCHAR(255) — NOT NULL — 배너 이미지
- link_url — VARCHAR(500) — 클릭 시 이동 URL
- position — VARCHAR(50) — 배너 위치: MAIN, SIDE, POPUP
- is_active — CHAR(1) — 활성화 여부(Y/N)
- start_date — DATE — 노출 시작일
- end_date — DATE — 노출 종료일
- seq — INT — 정렬순서
- click_count — INT — 클릭수
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
categories
- no — INT — Primary key — NOT NULL — PK
- name — VARCHAR(50) — NOT NULL — 카테고리명
- description — VARCHAR(200) — 카테고리 설명
- icon — VARCHAR(100) — 카테고리 아이콘
- seq — INT — 정렬순서
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
club_board_images
- no — INT — Primary key — NOT NULL — PK
- board_no — INT — Foreign key → club_boards.no — NOT NULL — FK
- image_url — VARCHAR(255) — NOT NULL
- seq — INT — 순서
club_board_likes
- no — INT — Primary key — NOT NULL — PK
- board_no — INT — Foreign key → club_boards.no — NOT NULL — FK
- user_no — INT — Foreign key → users.no — NOT NULL — FK
- created_at — TIMESTAMP — NOT NULL
club_boards
- no — INT — Primary key — NOT NULL — PK
- club_no — INT — Foreign key → clubs.no — NOT NULL — FK
- writer_no — INT — Foreign key → users.no — NOT NULL — FK
- title — VARCHAR(200) — NOT NULL — 제목
- content — TEXT — NOT NULL — 내용
- view_count — INT — 조회수
- like_count — INT — 좋아요 수
- comment_count — INT — 댓글 수
- is_notice — CHAR(1) — 공지 여부(Y/N)
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
club_comment_likes
- no — INT — Primary key — NOT NULL — PK
- comment_no — INT — Foreign key → club_comments.no — NOT NULL — FK: 댓글
- user_no — INT — Foreign key → users.no — NOT NULL — FK: 회원
- created_at — TIMESTAMP — NOT NULL
club_comments
- no — INT — Primary key — NOT NULL — PK
- board_no — INT — Foreign key → club_boards.no — NOT NULL — FK
- writer_no — INT — Foreign key → users.no — NOT NULL — FK
- content — VARCHAR(500) — NOT NULL — 댓글 내용
- like_count — INT — 좋아요 수
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
club_likes
- no — INT — Primary key — NOT NULL — PK
- club_no — INT — Foreign key → clubs.no — NOT NULL — FK
- user_no — INT — Foreign key → users.no — NOT NULL — FK
- created_at — TIMESTAMP — NOT NULL
club_member_reports
- no — INT — Primary key — NOT NULL — PK
- club_no — INT — Foreign key → clubs.no — NOT NULL — FK
- reporter_no — INT — Foreign key → users.no — NOT NULL — FK
- target_no — INT — Foreign key → users.no — NOT NULL — FK
- reason — VARCHAR(100) — 신고 사유 (욕설, 비매너 등)
- created_at — TIMESTAMP — NOT NULL
club_members
- no — INT — Primary key — NOT NULL — PK
- club_no — INT — Foreign key → clubs.no — NOT NULL — FK
- user_no — INT — Foreign key → users.no — NOT NULL — FK
- status — ENUM('PENDING', 'APPROVED', 'REJECTED') — 참가상태
- joined_at — TIMESTAMP — NOT NULL
clubs
- no — INT — Primary key — NOT NULL — PK
- host_no — INT — Foreign key → users.no — NOT NULL — FK
- category_no — INT — Foreign key → categories.no — NOT NULL — FK
- sub_category_no — INT — Foreign key → sub_categories.no — FK
- title — VARCHAR(100) — NOT NULL — 모임명
- description — TEXT — 모임 설명
- thumbnail_img — VARCHAR(255) — 썸네일 이미지
- max_members — INT — 모집 인원수
- current_members — INT — 현재 참가자 수
- deadline — DATE — 마감일
- location — VARCHAR(255) — 모임 장소
- club_date — DATETIME — 모임 일시
- status — ENUM('RECRUITING', 'CLOSED', 'COMPLETED') — 모임상태
- view_count — INT — 조회수
- like_count — INT — 좋아요 수
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
persistence_logins
- no — INT — NOT NULL — 번호
- id — VARCHAR(255) — NOT NULL — ID (UUID)
- user_id — VARCHAR(100) — NOT NULL — 회원 아이디
- token — VARCHAR(255) — NOT NULL — 인증 토큰
- expiry_date — TIMESTAMP — NOT NULL — 만료시간
- created_at — TIMESTAMP — NOT NULL — 등록일자
- updated_at — TIMESTAMP — NOT NULL — 수정일자
random_games
- no — INT — Primary key — NOT NULL — PK
- club_no — INT — Foreign key → clubs.no — NOT NULL — FK
- game_type — ENUM('ROULETTE', 'LADDER', 'RANDOM_PICK') — NOT NULL — 게임 종류: 돌림판/사다리/랜덤뽑기
- title — VARCHAR(100) — NOT NULL — 게임 제목
- options — JSON — 게임 옵션들
- result — VARCHAR(200) — 결과
- created_by — INT — Foreign key → users.no — NOT NULL — FK
- created_at — TIMESTAMP — NOT NULL
sub_categories
- no — INT — Primary key — NOT NULL — PK
- category_no — INT — Foreign key → categories.no — NOT NULL — FK: 대분류
- name — VARCHAR(50) — NOT NULL — 소분류명
- seq — INT — 정렬순서
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
user_auth
- no — INT — Primary key — NOT NULL — PK
- user_no — INT — Foreign key → users.no — NOT NULL — FK
- auth — VARCHAR(50) — NOT NULL — ROLE_USER, ROLE_HOST, ROLE_ADMIN
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
users
- no — INT — Primary key — NOT NULL — PK
- id — VARCHAR(64) — NOT NULL — UK (UUID)
- user_id — VARCHAR(100) — NOT NULL — 아이디(이메일)
- password — VARCHAR(100) — NOT NULL — 비밀번호(BCrypt)
- username — VARCHAR(100) — NOT NULL — 닉네임
- profile_img — VARCHAR(300)
- age — INT — 나이
- gender — VARCHAR(20)
- address — VARCHAR(255) — 주거지
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL