memo1

Tables (5)

category

  • Key (category_id) — INT — Primary key — NOT NULL
  • Field (category_name) — VARCHAR(50)

memo

  • Key (memo_id) — INT — Primary key — NOT NULL
  • Field (memo_title) — VARCHAR(255)
  • Field2 (memo_content) — TEXT
  • Field (memo_created) — DATETIME
  • Field2 (memo_updated) — DATETIME
  • Key (user_id) — INT — Foreign key → user.Key — NOT NULL
  • Key (category_id) — INT — Foreign key → category.Key — NOT NULL

reminder

  • Key (reminder_id) — INT — Primary key — NOT NULL
  • Field (reminder_at) — DATETIME
  • Field2 (reminder_created) — DATETIME
  • Key (memo_id) — INT — Foreign key → memo.Key — NOT NULL
  • Key (user_id) — INT — Foreign key → user.Key — NOT NULL
  • Field (reminder_recurring) — BOOLEAN

trash

  • Key (trash_id) — INT — Primary key — NOT NULL
  • Field (trash_at) — DATETIME
  • Key (user_id) — INT — Foreign key → user.Key — NOT NULL
  • Key (memo_id) — INT — Foreign key → memo.Key — NOT NULL

user

  • Key (user_id) — IN T — Primary key — NOT NULL
  • Field (user_name) — VARCHAR(50)
  • Field2 (user_email) — VARCHAR(100)
  • Field3 (user_password) — VARCHAR(255)
  • Field (user_created) — DATETIME
  • Field2 (user_updated) — DATETIME