Schedule
Tables (4)
alarm (3)
- schedule_id_fk (일정 고유번호) — int — Foreign key → schedule.schedule_id — NOT NULL
- alarm_time (Field2) — text
map (4)
- schedule_id_fk (일정 고유번호) — int — Foreign key → schedule.schedule_id — NOT NULL
- map_name (장소이름) — text
- map_latitude (장소위도) — double
- map_longitude (장소경도) — double
schedule (2)
- schedule_id (일정 고유번호) — int — Primary key — NOT NULL
- user_email_fk (유저 이메일) — text — Foreign key → user.user_email — NOT NULL
- schedule_context (일정내용) — text
- schedule_date (일정날짜) — text
- schedule_time (일정시각) — text
- schedule_state (일정삭제상태) — int
- schedule_registerDate (만들어진 시각) — TIMESTAMP
user (1)
- user_email (유저 이메일) — text — Primary key — NOT NULL
- user_name (유저 닉네임) — text