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