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 (비밀번호)