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