logit
테이블 (6)
place
- place_id — bigint — 기본 키 — NOT NULL
- tour_id — bigint — NOT NULL
- content — varchar(500) — NOT NULL
- image_url — text
- Field3 — VARCHAR(255)
- Field4 — varchar(100)
- Field — VARCHAR(255)
- Field2 — VARCHAR(255)
- order — int — NOT NULL
- created_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL
- status — varchar(100) — NOT NULL
tour
- tour_id — bigint — NOT NULL
- user_id — bigint — NOT NULL
- name — varchar(100) — NOT NULL
- budget — int — NOT NULL
- start_date — datetime
- time — int — NOT NULL
- image_url — text — NOT NULL
- content — varchar(5000) — NOT NULL
- created_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL
- status — varchar(100) — NOT NULL
tour_category
- tour_category_id — bigint — 기본 키 — NOT NULL
- tour_id — bigint — NOT NULL
- category_id2 — bigint — NOT NULL
- name — varchat(100) — NOT NULL
- created_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL
- status — varchar(100) — NOT NULL
user_language
- user_language_id — bigint — 기본 키 — NOT NULL
- user_id — bigint — NOT NULL
- language_id — bigint — NOT NULL
- created_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL
- status — varchar(100) — NOT NULL
user_review
- user_review_id — bigint — 기본 키 — NOT NULL
- review_id — VARCHAR(255) — NOT NULL
- user_id — bigint — NOT NULL
- created_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL
- status — varchar(100) — NOT NULL
사용자 (User)
- 유저ID (user_id) — bigint — 기본 키 — NOT NULL
- 이메일 (email) — varchar(100) — NOT NULL
- 비밀번호 (password) — varchar(255) — NOT NULL
- 이름 (name) — varchar(100) — NOT NULL
- 성별 (gender) — varchar(100) — NOT NULL