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