pre-study

Tables (3)

Copy Of USERS (COMMENTS)

  • Key (COMMENT_ID) — INT — Primary key — NOT NULL
  • Field (CONTENT) — TEXT
  • Field (DEPTH) — INT
  • Field2 (CREATED_AT) — DATETIME
  • Field2 (UPDATED_AT) — DATETIME
  • Key (POST_ID) — INT — Foreign key → USERS.Key — NOT NULL
  • Key (USER_ID) — INT — Foreign key → Untitled.Key — NOT NULL
  • Key (PARENT_ID) — INT — Foreign key → Copy Of USERS.Key — NOT NULL

USERS (POSTS)

  • Key (POST_ID) — INT — Primary key — NOT NULL
  • Field (TITLE) — VARCHAR(255)
  • Key (AUTHOR_ID) — INT — Foreign key → Untitled.Key — NOT NULL
  • Field (CONTENT) — TEXT
  • Field2 (CREATED_AT) — DATETIME
  • Field2 (UPDATED_AT) — DATETIME
  • Field2 (IS_PUBLISHED) — BOOLEAN

Untitled (USERS)

  • Key (USER_ID) — INT — Primary key — NOT NULL
  • Field (USERNAME) — VARCHAR(255)
  • Field (PASSWORD) — VARCHAR(255)
  • Field (CREATED_AT) — DATETIME
  • Field (UPDATED_AT) — DATETIME
  • Field (ROLE) — ENUM(USER, ADMIN)