community
Tables (3)
Board (Untitled2)
- Id (key) — BIGINT AHTO_INCREMENT PK — Primary key — NOT NULL
- title (board title) — VARCHAR(200) NOT NULL
- content (board content) — TEXT NOT NULL
- views (board views) — INT DEFAULT 0
- created_At (board created date) — DATE TIME DEFAULT CURRNET_TIMESTAMP
- updated_At (board updated date) — DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
- userId (user Id) — BIGINT NOT NULL FK — Foreign key → User.Id — NOT NULL
Comment (Untitled3)
- Id (key) — BIGINT AUTO_INCREMENT PK — Primary key — NOT NULL
- content (comment content) — TEXT NOT NULL
- created_At (comment create date) — DATETIME DEFAULT CURRENT_TIMESTAMP
- userId (user Id) — BIGINT NOT NULL FK — Foreign key → User.Id — NOT NULL
- boardId (board Id) — BIGINT NOT NULL FK — Foreign key → Board.Id — NOT NULL
- parentId (parent Id) — BIGINT NOT NULL FK — Foreign key → Comment.Id — NOT NULL
User (Untitled)
- Id (key) — BIGINT AUTO_INCREMENT PK — Primary key — NOT NULL
- userId (user Id) — VARCHAR(50) NOT NULL UNIQUE
- password (user password) — VARCHAR(255) NOT NULL
- nickname (user nickname) — VARCHAR(30) NOT NULL UNIQUE
- role — ENUM ('USER' , 'ADMIN') NOT NULL DEFAULT 'USER'
- created_At (user created date) — DATETIME DEFAULT CURRENT_TIMESTAMP
- updated_At (user updated date) — DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
- deleted_At (user deleted date) — DATETIME NULL DEFAULT NULL