Ktrip

Tables (3)

Favorite (선호하는 여행지)

  • fav_id (Key) — INTEGER — Primary key — NOT NULL
  • member_id (Key2) — INTEGER — Foreign key → Member.member_id — NOT NULL
  • region (Field) — VARCHAR(20)

Member (Untitled)

  • member_id (Key) — INTEGER — Primary key — NOT NULL
  • id (로그인 id) — VARCHAR(20)
  • email (Field2) — VARHCAR(20)
  • Field3 — VARCHAR(255)
  • nickname (유저닉네임) — VARCHAR(20)
  • name (유저 이름) — VARCHAR(20)
  • access_token (Field) — VARCHAR(255)
  • refresh_token (Field4) — VARCHAR(255)
  • TYPE (Field5) — VARCHAR(20)

Review (관광지 후기)

  • review_id (Key) — INTEGER — Primary key — NOT NULL
  • member_id (Key3) — INTEGER — Foreign key → Member.member_id — NOT NULL
  • point (Field) — INTEGER
  • content (Field2) — VARCHAR(255)