가서뭐해?
테이블 (6)
Copy Of Copy Of user2 (participant)
- id — BIGINT — 기본 키 — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
- deleted_at — TIMESTAMP
- id (user_id) — BIGINT — 외래 키 → user.id — NOT NULL
- id (travel_id) — BIGINT — 외래 키 → Copy Of user.id — NOT NULL
Copy Of user (travel)
- id — BIGINT — 기본 키 — NOT NULL
- Field (name) — varchar(50) — NOT NULL
- Field (destination) — varchar(50) — NOT NULL
- Field (start_date) — DATE — NOT NULL
- Field (end_date) — DATE — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
- deleted_at — TIMESTAMP
Copy Of user2 (schedule)
- id — BIGINT — 기본 키 — NOT NULL
- Field (date) — DATE — NOT NULL
- Field (start_time) — TIME — NOT NULL
- Field (end_time) — TIME — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
- deleted_at — TIMESTAMP
- id (travel_id) — BIGINT — 외래 키 → Copy Of user.id — NOT NULL
- id (place_id) — BIGINT — 외래 키 → Copy Of user3.id — NOT NULL
Copy Of user3 (place)
- id — BIGINT — 기본 키 — NOT NULL
- Field (name) — VARCHAR(100) — NOT NULL
- Field (thumbnail) — VARCHAR(200)
- Field (address) — VARCHAR(100) — NOT NULL
- Field (roadAddress) — VARCHAR(100) — NOT NULL
- Field (category) — VARCHAR(100) — NOT NULL
- Field (phone) — VARCHAR(100)
- Field (url) — VARCHAR(100)
- Field (x) — DECIMAL(9, 6) — NOT NULL
- Field (y) — DECIMAL(9, 6) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
- deleted_at — TIMESTAMP
Copy Of user4 (review)
- id — BIGINT — 기본 키 — NOT NULL
- Field (rating) — TINYINT — NOT NULL
- Field (content) — TEXT — NOT NULL
- Field (image) — VARCHAR(200)
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
- deleted_at — TIMESTAMP
- id (user_id) — BIGINT — 외래 키 → user.id — NOT NULL
- id (place_id) — BIGINT — 외래 키 → Copy Of user3.id — NOT NULL
user
- id — BIGINT — 기본 키 — NOT NULL
- Field (name) — VARCHAR(20) — NOT NULL
- Field (email) — VARCHAR(50) — NOT NULL
- Field (password) — VARCHAR(100) — NOT NULL
- Field (profile_image) — VARCHAR(200) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
- deleted_at — TIMESTAMP