package
Tables (6)
Category
- category_id — BIGINT — Primary key — NOT NULL
- name — VARCHAR(50)
- Field
TemplateItem (Template Item(AI Based on this Table))
- template_item_id — BIGINT — Primary key — NOT NULL
- name — VARCHAR(50)
- defatul_quantity — INT
- gender — enum: MALE,FEMALE
- destination_type — enum: BEACH, MOUNTAIN, CITY, etc
- weather_condition — enum: COLD, HOT, RAINY
- is_default — boolean
- category_id — BIGINT — Foreign key → Category.category_id — NOT NULL
Trip
- trip_id — BIGINT — Primary key — NOT NULL
- title — VARCHAR(50)
- location — VARCHAR(50)
- start_date — TIMESTAMP
- end_date — TIMESTAMP
- created_at — TIMESTAMP
- travel_type — enum: HEALING, TOUR, ADVENTURE, FAMILY, BUSINESS, etc
- companions — INT
- companion_type — enum: FRIEND, FAMILY, COUPLE
- user_id — BIGINT — Foreign key → User.user_id — NOT NULL
TripItem
- trip_item_id — BIGINT — Primary key — NOT NULL
- item_name — VARCHAR(50)
- quantity — INT
- is_checked — boolean
- is_ai_recommended — boolean
- notes — VARCHAR(50
- trip_id — BIGINT — Foreign key → Trip.trip_id — NOT NULL
- category_id — BIGINT — Foreign key → Category.category_id — NOT NULL
- recommendation_id — BIGINT — Foreign key → TripItemRecommendation.recommendation_id — NOT NULL
- template_item_id — BIGINT — Foreign key → TemplateItem.template_item_id — NOT NULL
TripItemRecommendation
- recommendation_id — BIGINT — Primary key — NOT NULL
- custom_item_name — VARCHAR(50)
- is_selected — boolean
- recommended_at — TIMESTAMP
- trip_id — BIGINT — Foreign key → Trip.trip_id — NOT NULL
- category_id — BIGINT — Foreign key → Category.category_id — NOT NULL
- template_item_id — BIGINT — Foreign key → TemplateItem.template_item_id — NOT NULL
User
- user_id — BIGINT — Primary key — NOT NULL
- age — INT
- gender — ENUM("male, female))
- name — VARCHAR(50)
- created_at — TIMESTAMP