hana
Tables (4)
LIKE (Like)
- ID (Id) — int — Primary key — NOT NULL
- 유저 아이디 (user_id) — int — Foreign key → User.유저 아이디 — NOT NULL
- postid (postId) — int — NOT NULL
- liked — boolean — NOT NULL
- postid (postId2) — int — Foreign key → Post.postid — NOT NULL
- cID (cId2) — int — Foreign key → Post.cID — NOT NULL
Post
- postid (postId) — int — Primary key — NOT NULL
- cID (cId2) — int — Foreign key → category.cID — NOT NULL
- userid (userId) — int — NOT NULL
- title — varchar(60) — NOT NULL
- content — text — NOT NULL
- createDt — timestamp — NOT NULL
- updateDt — timestamp — NOT NULL
- cId — int — NOT NULL
- 유저 아이디 (user_id) — int — Foreign key → User.유저 아이디 — NOT NULL
User
- 유저 아이디 (user_id) — int — Primary key — NOT NULL
- name — varchar(31) — NOT NULL
- email — varchar(255) — NOT NULL
- password — varchar(255) — NOT NULL
- nickname — varchar(31) — NOT NULL
- isAdmin — boolean — NOT NULL
category
- cID (cId) — int — Primary key — NOT NULL
- category — varchar(31) — NOT NULL