TravelApp (3)
Tables (5)
Trip
- Key (id) — BIGINT — Primary key — NOT NULL
- Key (member_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL
- Field (name) — VARCHAR(100) — NOT NULL
- Field2 (start_date) — DATE — NOT NULL
- Field3 (end_date) — DATE — NOT NULL
- Field (is_foreign) — TINYINT(1) — NOT NULL
- Field (like_count) — BIGINT — NOT NULL
- Field (created_date) — TIMESTAMP — NOT NULL
- Field (updated_date) — TIMESTAMP — NOT NULL
Untitled (Itinerary)
- Key (id) — BIGINT — Primary key — NOT NULL
- Key (trip_id) — BIGINT — Foreign key → Trip.Key — NOT NULL
- Field (transporation) — VARCHAR(100)
- Field2 (departure_place_name) — VARCHAR(100)
- Field3 (departure_address) — VARCHAR(200)
- Field (destination_place_name) — VARCHAR(100)
- Field2 (destination_address) — VARCHAR(200)
- Field (departure_at) — DATETIME
- Field2 (arrive_at) — DATETIME
- Field (lodge_place_name) — VARCHAR(100)
- Field (lodge_address) — VARCHAR(200)
- Field (check_in_at) — DATETIME
- Field2 (check_out_at) — DATETIME
- Field (stay_place_name) — VARCHAR(100)
- Field2 (stay_address) — VARCHAR(200)
- Field (stay_start_at) — DATETIME
- Field3 (stay_end_at) — DATETIME
- Field (created_date) — TIMESTAMP — NOT NULL
- Field2 (updated_date) — TIMESTAMP — NOT NULL
Untitled (Member)
- Key (id) — BIGINT — Primary key — NOT NULL
- Field2 (email) — VARCHAR(500) — NOT NULL
- Field3 (name) — VARCHAR(30) — NOT NULL
- Field (nickname) — VARCHAR(30) — NOT NULL
- Field (password) — VARCHAR(1000) — NOT NULL
- Field (created_date) — TIMESTAMP — NOT NULL
- Field2 (updated_date) — TIMESTAMP — NOT NULL
Untitled (Like)
- Key (id) — BIGINT — Primary key — NOT NULL
- Key (member_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL
- Key (trip_id) — BIGINT — Foreign key → Trip.Key — NOT NULL
- Field (created_date) — TIMESTAMP — NOT NULL
- Field2 (updated_date) — TIMESTAMP — NOT NULL
Untitled (Comment)
- Key (id) — Primary key — NOT NULL
- Key (member_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL
- Key (trip_id) — BIGINT — Foreign key → Trip.Key — NOT NULL
- Field (content) — VARCHAR(1000) — NOT NULL
- Field (created_date) — TIMESTAMP — NOT NULL
- Field2 (updated_date) — TIMESTAMP — NOT NULL