todoone

Tables (4)

Calendar (calendar_table)

  • calendarId (calendar_id) — BIGINT — Primary key — NOT NULL
  • userId (user_id2) — BIGINT — Foreign key → User.userId — NOT NULL
  • coupleId (couple_id) — BIGINT — Foreign key → User.coupleId
  • dateStart (date_start) — DATE
  • dateEnd (date_end) — DATE
  • title — VARCHAR
  • nickname — VARCHAR
  • together — TINYINT

Couple (couple_table)

  • coupleId (couple_id) — BIGINT — Primary key — NOT NULL
  • userId1 (user_id1) — BIGINT — Foreign key → User.userId — NOT NULL
  • userId2 (user_id2) — BIGINT — Foreign key → ToDo.todoId — NOT NULL

ToDo (todo_table)

  • todoId (todo_id) — BIGINT — Primary key — NOT NULL
  • userId (user_id2) — BIGINT — Foreign key → User.userId — NOT NULL
  • coupleId (couple_id) — BIGINT — Foreign key → User.coupleId
  • content — VARCHAR
  • date — DATE
  • completeStatus (complete_status) — TINYINT
  • together — TINYINT

User (user_table)

  • userId (user_id) — BIGINT — Primary key — NOT NULL
  • code — BIGINT — Primary key
  • coupleId (couple_id) — BIGINT — Primary key
  • name — VARCHAR
  • email — VARCHAR
  • password — VARCHAR
  • birth — DATE
  • gender — TINYINT
  • allowNotification (allow_notification) — TINYINT
  • nickname — VARCHAR