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