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)