mindary

Tables (3)

chat (chats)

  • id — INTEGER — Primary key
  • writer (user_id) — INTEGER — Foreign key → user.id
  • content — TEXT
  • created_at — DATETIME

record (records)

  • id — INTEGER — Primary key
  • writer (user_id) — INTEGER — Foreign key → user.id
  • category — VARCHAR(30)
  • title — TEXT
  • content — TEXT
  • created_at — DATETIME
  • edited_at — DATETIME
  • liked — BOOLEAN

user (users)

  • id — INTEGER — Primary key
  • email — VARCHAR(255) — NOT NULL
  • nickname — VARCHAR(30) — NOT NULL
  • password — VARCHAR(128)