ER Diagram
erDiagram
User {
id int PK
email varchar(30) "not null"
password_hash varchar(20) "not null"
nickname varchar(30) "not null"
profile varchar(200)
created_at datetime
updated_at datetime
}
Trip {
id int PK
creator_id int FK
title varchar(100)
start_date datetime
end_date datetime
created_at datetime
updated_at datetime
}
Day {
id int PK
trip_id int Fk
start_time datetime
orderNum int
}
~~~~
Schedule {
id int PK
day_id int FK
place_name varchar(20)
trip_id int FK
orderNum int
lat double
lng double
type int
potition_path varchar(1000)
site_id varcher(100)
}
Route {
id int PK
trip_id int FK
day_id int FK
orderNum int
drive_duration int
trans_duration int
}
TripMember {
id int PK
trip_id int FK
user_id int FK
isOwner bool
}
PhotoAlbum {
id int PK
trip_id int FK
image_url varchar(200)
}
PhotoPlace {
id int PK
album_id int FK
name varchar(10)
}
Photo {
id int PK
album_id int FK
photo_place int FK
user_id int FK
file_path varchar(200)
latitude float
longitude float
taken_at datetime
uploaded_at datetime
}
Comment {
id int PK
photo_id int FK
author id
content varchar(200)
created_at datetime
updated_at datetime
}
User ||--o{ Trip : "creates"
Trip ||--o{ Day: "has"
Day||--o{ Schedule : "has"
Day||--o{ Route: "has"
Trip ||--o{ TripMember : "has"
Trip ||--o{ PhotoAlbum : "has"
PhotoAlbum ||--o{ PhotoPlace : "contains"
PhotoAlbum ||--o{ Photo : "contains"
Photo ||--o{ Comment : "has"
User ||--o{ Comment : "writes"
User ||--o{ Photo : "uploads"
User ||--o{ TripMember : "joins"
PhotoPlace ||--o{ Photo : "linked"