AIVersion of package
Tables (7)
AiRecommendationLog
- ai_recommend_id — BIGINT — Primary key — NOT NULL
- item_name — VARCHAR(50)
- is_selected — boolean
- created_at — TIMESTAMP
- trip_category_id — BIGINT — Foreign key → TripCategory.trip_category_id — NOT NULL
Category
- category_id — BIGINT — Primary key — NOT NULL
- name — VARCHAR(50)
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
TripCategory
- trip_category_id — BIGINT — Primary key — NOT NULL
- name — VARCHAR(50)
- trip_id — BIGINT — Foreign key → Trip.trip_id — NOT NULL
- sort_order — int
- is_completed — boolean
- category_id (base_category_id) — BIGINT — Foreign key → Category.category_id
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_category_id — BIGINT — Foreign key → TripCategory.trip_category_id — NOT NULL
User
- user_id — BIGINT — Primary key — NOT NULL
- age — INT
- gender — ENUM("male, female))
- name — VARCHAR(50)
- created_at — TIMESTAMP