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)