BBS
Tables (4)
bbs
- seq — INT — Primary key — NOT NULL
- id — VARCHAR(50) — Foreign key → member.id — NOT NULL
- ref — VARCHAR(50)
- step — DECIMAL(8,0)
- depth — DECIMAL(8,0)
- title — VARCHAR(200)
- content — VARCHAR(4000)
- wdate — TIMESTAMP
- del — DECIMAL(1,0)
- readcount — DECIMAL(8,0)
comments
- id — INT — Primary key — NOT NULL
- seq — INT — Foreign key → bbs.seq — NOT NULL
- member_id — VARCHAR(50)
- content — VARCHAR(1000)
- wdate — TIMESTAMP
- del — DECIMAL(1,0)
member
- id — VARCHAR(50) — Primary key — NOT NULL
- pwd — VARCHAR(50)
- name — VARCHAR(50)
- email — VARCHAR(50)
- auth — DECIMAL(1,0)
readcounts
- seq — INT
- member_id — VARCHAR(50)
- rdate — TIMESTAMP