1234
Tables (4)
article
- no — INTEGER — Primary key
- title — VARCHAR(100) — NOT NULL
- thumbnail — longtext
- description — longtext — NOT NULL
- content — longtext — NOT NULL
- reg_date — TIMESTAMP — NOT NULL
- modify_date — TIMESTAMP — NOT NULL
- like_count — INTEGER
- hate_count — INTEGER
- read_count — INTEGER
- category — VARCHAR(50) — Foreign key → category.category
category
- category — VARCHAR(50) — Primary key
member
- id — VARCHAR(100) — Primary key
- pass — VARCHAR(100) — NOT NULL
- name — VARCHAR(10) — NOT NULL
- email — VARCHAR(100) — NOT NULL
- reg_date — TIMESTAMP — NOT NULL
reply
- no — INTEGER — Primary key
- bbs_no — integer — NOT NULL
- content — VARCHAR(100) — NOT NULL
- reg_date — TIMESTAMP — NOT NULL
- writer — VARCHAR(100) — Foreign key → member.id
- no (no2) — INTEGER — Foreign key → article.no