project
Tables (8)
file
- file_no — INT(100) — Primary key — NOT NULL
- post_no — INT(5) — NOT NULL
- filename — VARCHAR(200)
- rfilename — VARCHAR(200)
follow
- username — VARCHAR(100) — NOT NULL
- follow — VARCHAR(100)
like
- post_no — INT(5) — NOT NULL
- username — VARCHAR(100) — NOT NULL
- reply_no — INT(5) — NOT NULL
login
- id — VARCHAR(100) — Primary key — NOT NULL
- pw — VARCHAR(100)
post
- post_no — INT(5) — Primary key — NOT NULL
- username — VARCHAR(100) — NOT NULL
- text — CHAR(2000)
- writedate — DATE
- likeHit — INT(100)
- default=0 — NULL
reply
- reply_no — INT(5) — Primary key — NOT NULL
- username — VARCHAR(100) — NOT NULL
- post_no — INT(5) — NOT NULL
- gup — INT(5)
- lev — INT(2)
- seq — INT(5)
- re_text — VARCHAR(200)
- writedate — DATE
- Field — VARCHAR(255)
tag
- post_no — INT(5) — NOT NULL
- reply_no — INT(5) — NOT NULL
- username — VARCHAR(100) — NOT NULL
- Field — VARCHAR(100)
userinfo
- username — VARCHAR(100) — Primary key — NOT NULL
- id — VARCHAR(100) — NOT NULL
- profile — VARCHAR(200)
- birth — Date(7)
- phone — VARCHAR(20)
- email — VARCHAR(100)
- sex — CHAR(1)
- default=1 — NULL
- intro — VARCHAR(500)
- joindate — Date
- default=sysdate — NULL