minVersion of package

Tables (6)

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
  • category_id (category_id2) — BIGINT — Foreign key → Category.category_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_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