bb
Tables (6)
Comment
- commentIdx — int — Primary key — NOT NULL
- postIdx — int — Foreign key → Post.postIdx — NOT NULL
- userIdx — int — Foreign key → User.userIdx — NOT NULL
- content — varchar(100)
- createdAt — timestamp
- updatedAt — timestamp
- status — varchar(10)
Post
- postIdx — int — Primary key — NOT NULL
- userIdx — int — Foreign key → User.userIdx — NOT NULL
- Field (title) — varchar(50)
- content — varchar(500)
- createdAt — timestamp
- updatedAt — timestamp
- status — varchar(10)
Untitled (Like)
- Key (likeIdx) — int — Primary key — NOT NULL
- postIdx — int — Foreign key → Post.postIdx — NOT NULL
- userIdx — int — Foreign key → User.userIdx — NOT NULL
- Field (createdAt) — timestamp
- Field (updatedAt) — timestamp
- Field (status) — varchar(10)
Untitled (Level)
- Key (levelIdx) — int — Primary key — NOT NULL
- userIdx — int — Foreign key → User.userIdx — NOT NULL
- Field (level) — varchar(0)
Untitled (DoubleComment)
- Key (DCommentIdx) — int — Primary key — NOT NULL
- commentIdx — int — Foreign key → Comment.commentIdx — NOT NULL
- Key (levelIdx) — int — Foreign key → Untitled.Key — NOT NULL
- Field (content) — varchar(100)
- Field (createdAt) — timestamp
- Field (updatedAt) — timestamp
- Field (status) — varchar(10)
User
- userIdx — int — Primary key — NOT NULL
- name — varchar(15)
- id — varchar(15)
- pwd — varchar(20)
- createdAt — timestamp
- updatedAt — timestamp
- status — varchar(10)