DAGEU

Tables (4)

Place (Untitled4)

  • place_id (PK) — Primary key — NOT NULL
  • place_type (맛집/호텔/명소 타입)
  • name (이름)
  • address (주소)
  • rate (평점)
  • imageurl (Field)

Plan (Untitled2)

  • plan_id (PK) — Primary key — NOT NULL
  • user_id (유저) — Foreign key → User.user_id — NOT NULL
  • title (Field)
  • budget (Field2)
  • sex (Field3)
  • startdate (Field4)
  • endDate (Field5)

Schedule (Untitled3)

  • schedule_id (PK) — Primary key — NOT NULL
  • plan_id (계획) — Foreign key → Plan.plan_id — NOT NULL
  • start_date (시작 시간)
  • end_date (종료 시간)
  • schedule_text (내용)
  • place_id (PK2) — Foreign key → Place.place_id — NOT NULL

User (Untitled)

  • user_id (PK) — Primary key — NOT NULL
  • userName (이름)
  • loginId (로그인ID)
  • userPw (비밀번호)