Trip
Tables (6)
Auth (auth)
- id (토큰식별아이디) — NN — Primary key — NOT NULL
- refresh_token (리프레시토큰) — NN
- created_at (생성날짜) — NN
- updated_at (수정날짜) — NN
Nation (nation)
- id (국가식별아이디) — NN — Primary key — NOT NULL
- code (국가코드) — NN
- label (국가이름) — NN
- url (이미지url) — NN
Participant (participant)
- id (참여자식별아이디) — NN — Primary key — NOT NULL
- user_id (유저식별아이디) — NN — Foreign key → User.id — NOT NULL
- plan_id (플랜식별아이디) — NN — Foreign key → Plan.id — NOT NULL
- Field
Plan (plan)
- id (플랜식별아이디) — NN — Primary key — NOT NULL
- nation_id (국가식별아이디) — NN — Foreign key → Nation.id — NOT NULL
- title (제목) — NN
- start_date (시작일) — NN
- end_date (종료일) — NN
- invite_code (초대코드) — NN
- Field
User (user)
- id (유저식별아이디) — NN — Primary key — NOT NULL
- token_id (토큰식별아이디) — Foreign key → Auth.id — NOT NULL
- signname (유저아이디) — NN
- password (비밀번호) — NN
- name (이름) — NN
- nickname (닉네임) — NN
- email (이메일) — NN
- varify_email (이메일인증여부) — NN
- is_withdraw (탈퇴여부) — NN
- created_at (생성날짜) — NN
- updated_at (수정날짜) — NN
- withdraw_at (탈퇴날짜) — NN
Varifications (varifications)
- id (식별아이디) — NN — Primary key — NOT NULL
- user_id (유저식별아이디) — NN — Foreign key → User.id — NOT NULL
- type (타입) — NN
- to (주소) — NN
- token (토큰) — NN
- key (키값) — NN
- created_at (생성날짜) — NN
- updated_at (수정날짜) — NN