KTB5_Gianna_Week5
Tables (4)
Comment (comments)
- commentId (id) — BIGINT — Primary key — NOT NULL — UNSIGNED, AUTO_INCREMENT
- 게시글 ID (postId) — BIGINT — Foreign key → Post.postId — NOT NULL — UNSIGNED
- 사용자 ID (userId) — INT — Foreign key → User.사용자 ID — NOT NULL — UNSIGNED
- content — VARCHAR(200) — NOT NULL
- created_at (createdAt) — DATETIME — NOT NULL
- Field (updatedAt) — DATETIME — DEFAULT CURRENT_TIMESTAMP, default null
- Field (deletedAt) — DATETIME — default - null
Post (posts)
- postId (id) — BIGINT — Primary key — NOT NULL — UNSIGNED, AUTO_INCREMENT
- userId — INT — Foreign key → User.사용자 ID — NOT NULL — UNSIGNED
- created_at (createdAt) — DATETIME — NOT NULL — DEFAULT CURRENT_TIMESTAMP
- title — VARCHAR(20) — NOT NULL
- content — VARCHAR(1000) — NOT NULL
- file (postFile) — VARCHAR(255)
- Field (updatedAt) — DATETIME — DEFAULT CURRENT_TIMESTAMP, default null
- Field (deletedAt) — DATETIME — default.- null
Untitled (deletedUsers)
- 사용자 ID (id) — INT — Foreign key → User.사용자 ID — NOT NULL — UNSIGNED, AUTO_INCREMENT
- Field (email) — VARCHAR(255) — NOT NULL — UNIQUE
- Field (nickname) — VARCHAR(10) — NOT NULL — UNIQUE
User (users)
- 사용자 ID (id) — INT — Primary key — NOT NULL — UNSIGNED, AUTO_INCREMENT
- nickname — VARCHAR(10) — NOT NULL — UNIQUE
- email — VARCHAR(255) — NOT NULL — UNIQUE
- password — VARCHAR(255) — NOT NULL
- profilePicture — VARCHAR(255) — NOT NULL
- deletedAt — DATETIME — default - null