pilot
Tables (4)
like_to
- lno — bigint — Primary key
- pno (pno2) — bigint — Foreign key → post.pno
- uno (uno2) — bigint — Foreign key → post.uno
- pno — bigint — NOT NULL
- uno — bigint — NOT NULL
post
- pno — bigint — Primary key
- uno (uno2) — bigint — Foreign key → user.uno
- create_date — timestamp
- modified_date — timestamp
- image_path — varchar(250)
- like_count — integer
- music_path — varchar(250)
- title — varchar(500) — NOT NULL
- uno — bigint — NOT NULL
- content — Text — NOT NULL
reply
- rno — bigint — Primary key
- pno (pno2) — bigint — Foreign key → post.pno
- uno (uno2) — bigint — Foreign key → post.uno
- uno (uno3) — bigint — Foreign key → user.uno
- create_date — timestamp
- modified_date — timestamp
- content — Text
- image_path — varchar(255)
- parent — integer
- pno — bigint — NOT NULL
- state — boolean
- uno — bigint — NOT NULL
user
- uno — bigint — Primary key
- create_date — timestamp
- modified_date — timestamp
- email — varchar(255) — NOT NULL
- nickname — varchar(255) — NOT NULL
- password — varchar(255) — NOT NULL