ex-it

Tables (10)

auth (보안)

  • auth_id (보안고유번호) — Primary key — NOT NULL
  • user_id (유저고유번호)
  • type (카카오/네이버/페북)
  • access_token (access 토큰)
  • refresh_token (refresh 토큰)
  • email (소셜로그인시 사용한 이메일)

inquiry (문의)

  • inquiry_id (문의고유번호) — Primary key — NOT NULL
  • user_id (유저고유번호) — Foreign key → user.user_id — NOT NULL
  • title (문의제목)
  • type (문의종류)
  • content (문의내용)

reply (답변)

  • reply_id (Key) — Primary key — NOT NULL
  • inquiry_id (문의고유번호) — Foreign key → inquiry.inquiry_id — NOT NULL
  • title (답변제목)
  • type (답변종류)
  • content (답변내용)

review (리뷰)

  • review_id (리뷰고유번호) — Primary key — NOT NULL
  • user_id (유저고유번호) — Foreign key → user.user_id — NOT NULL
  • title (리뷰제목)

room (대화방)

  • room_id (방 고유번호) — Primary key — NOT NULL
  • user_id (개설유저고유번호) — Foreign key → user.user_id — NOT NULL
  • username (유저 이름)
  • title (방제)
  • max_occupancy (최대 인원 수용량)
  • current_occupancy (현재 인원)
  • state (방의 상태)
  • communication (채팅 / 통화)
  • hardcore (하드코어 유무)
  • created_at (방 개설 시간)
  • observer (옵저버 최대 숫자)

roomJoin (채팅방 접속 관리)

  • room_id (방 고유번호) — Foreign key → room.room_id — NOT NULL
  • user_id (유저고유번호) — Foreign key → user.user_id — NOT NULL
  • status (1:host / 2:guest / 3:observer)
  • talk_time (채팅+통화시간)
  • call_time (통화시간)

roomTag (태그관리)

  • tag_id (테그고유번호) — Foreign key → tag.tag_id — NOT NULL
  • room_id (방 고유번호) — Foreign key → room.room_id — NOT NULL

settings (환경설정)

  • id (환경설정고유번호) — Primary key — NOT NULL
  • alarm (Field)
  • Field2
  • Field3
  • Field4
  • Field5

tag (태그)

  • tag_id (테그고유번호) — Primary key — NOT NULL
  • name (태그 이름)
  • is_popular (인기태그?)

user (사용자)

  • user_id (유저고유번호) — Primary key — NOT NULL
  • settings_id (환경설정고유번호) — Foreign key → settings.id — NOT NULL
  • auth_id (보안고유번호) — Foreign key → auth.auth_id — NOT NULL
  • email (이메일)
  • password (비밀번호)
  • nickname (닉네임)
  • phone (전화번호)
  • birth (생년월일)
  • sex (성별)
  • terms (약관동의)
  • created_at (가입날짜)
  • updated_at (로그인날짜)
  • uuid
  • token (혹시모를 토큰값)
  • is_authenticated (boolean)