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"