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 (Key2) — INTEGER — Foreign key → Member.member_id — NOT NULL
- point (Field) — INTEGER
- content (Field2) — VARCHAR(255)