아자아자화이팀
테이블 (7)
city
- id — BIGINT — NOT NULL
- name — VARCHAR(50) — NOT NULL
- latitude — DOUBLE
- longitude — DOUBLE
event
- event_id — BIGINT — NOT NULL
- title — VARCHAR(255)
- description — VARCHAR(255)
- imageUrl — VARCHAR(255)
- date — VARCHAR(255)
member
- member_id — BIGINT — NOT NULL
- email — VARCHAR(100) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- name — VARCHAR(50) — NOT NULL
- phone_number — VARCHAR(20)
- role — VARCHAR(20) — NOT NULL
- created_at — DATETIME
- updated_at — DATETIME
place
- id — BIGINT — NOT NULL
- city_id — BIGINT — 외래 키 → city.id — NOT NULL
- name — VARCHAR(200) — NOT NULL
- address — VARCHAR(255) — NOT NULL
- latitude — DOUBLE
- longitude — DOUBLE
- type — VARCHAR(30) — NOT NULL
- category — VARCHAR(50)
- description — TEXT
- remark — VARCHAR(255)
- image_url — VARCHAR(500)
- created_at — DATETIME
- updated_at — DATETIME
route
- id — BIGINT — NOT NULL
- user_id — BIGINT — 외래 키 → member.member_id
- jsonData — TEXT
trip
- id — BIGINT — NOT NULL
- user_id — BIGINT — 외래 키 → member.member_id — NOT NULL
- title — VARCHAR(200) — NOT NULL
- date — DATE
- notes — TEXT
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME
trip_place
- id — BIGINT — NOT NULL
- trip_id — BIGINT — 외래 키 → trip.id
- name — VARCHAR(255)
- type — VARCHAR(255)
- lat — DOUBLE
- lng — DOUBLE
- orderIndex — INT