IRIS

Tables (3)

codex

  • id — bigint(20) — Primary key — NOT NULL
  • user_id — bigint(20) — Foreign key → user.id — NOT NULL
  • title — varchar(50)
  • created_at — datetime — NOT NULL
  • description — varchar(255) — NOT NULL

post

  • id — bigint(20) — Primary key — NOT NULL
  • codex_id — bigint(20) — Foreign key → codex.id — NOT NULL
  • content — JSON — NOT NULL
  • title — varchar(50) — NOT NULL
  • created_at — datetime — NOT NULL
  • last_modified_at — datetime

user

  • id — bigint(20) — Primary key — NOT NULL
  • name — varchar(15) — NOT NULL
  • email — varchar(30) — NOT NULL
  • created_at — datetime — NOT NULL
  • withdraw_at — datetime
  • provider — varchar(255) — NOT NULL
  • password — varchar(50)