chain
Tables (5)
Comment (댓글)
- Key (회원 ID) — BIGINT — Foreign key → User.Key — NOT NULL
- Key (게시물 ID) — BIGINT — Foreign key → Post.Key — NOT NULL
- Field (내용) — VARCHAR(300) — NOT NULL
- Field (시각) — DATETIME — NOT NULL
Favorite (즐겨찾기)
- Key (회원 ID) — BIGINT — Foreign key → User.Key — NOT NULL
- Key (게시물 ID) — BIGINT — Foreign key → Post.Key — NOT NULL
Like (좋아요)
- Key (회원 ID) — BIGINT — Foreign key → User.Key — NOT NULL
- Key (게시물 ID) — BIGINT — Foreign key → Post.Key — NOT NULL
- Field (시각) — DATETIME — NOT NULL
Post (게시물)
- Key (게시물 ID) — BIGINT — Primary key — NOT NULL
- Key (회원 ID) — BIGINT — Foreign key → User.Key — NOT NULL
- Field (카테고리) — VARCHAR(20)
- Field (태그) — VARCHAR(20)
- Field (제목) — VARCHAR(255) — NOT NULL
- Field (내용) — VARCHAR(3000) — NOT NULL
- Field (시각) — DATETIME — NOT NULL
User (사용자)
- Key (회원 ID) — BIGINT — Primary key — NOT NULL
- Field (사용자 이름) — VARCHAR(20) — NOT NULL
- Field (이메일) — VARCHAR(320) — NOT NULL
- Field (비밀번호) — VARCHAR(50) — NOT NULL