dashborad

Tables (4)

comments

  • id — BIGINT
  • post_id — BIGINT — Foreign key — NOT NULL
  • content — TEXT — NOT NULL
  • is_deleted — BOOLEAN
  • created_at — DATETIME
  • updated_at — DATETIME
  • deleted_at — DATETIME
  • id (id2) — BIGINT — Foreign key → users.id
  • id (id3) — BIGINT — Foreign key → users.id
  • Key — Foreign key → posts.id — NOT NULL

files

  • id — BIGINT
  • post_id — BIGINT — Foreign key — NOT NULL
  • original_name — VARCHAR(255)
  • stored_name — VARCHAR(255)
  • file_path — VARCHAR(500)
  • file_size — BIGINT
  • content_type — VARCHAR(100)
  • created_at — DATETIME
  • id (id2) — BIGINT — Foreign key → users.id
  • id (id3) — BIGINT — Foreign key → users.id
  • Key — Foreign key → posts.id — NOT NULL

posts

  • id — BIGINT — Primary key — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • content — TEXT — NOT NULL
  • is_deleted — BOOLEAN
  • created_at — DATETIME
  • updated_at — DATETIME
  • deleted_at — DATETIME
  • is_pinned — BOOLEAN
  • id (id2) — BIGINT — Foreign key → users.id
  • id (id3) — BIGINT — Foreign key → users.id

users

  • id — BIGINT — Primary key
  • user_id — BIGINT
  • password — VARCHAR(255)
  • nickname — VARCHAR(50) — NOT NULL
  • role — VARCHAR(20) — NOT NULL
  • provider — VARCHAR(20) — NOT NULL
  • provider_id — VARCHAR(100)
  • status — VARCHAR(20) — NOT NULL
  • created_at — DATETIME
  • updated_at — DATETIME
  • deleted_at — DATETIME