board
Tables (4)
CATEGORY (카테고리)
- CATEGORY_ID (PK) — INT — Primary key — NOT NULL
- NAME (Field) — VARCHAR(10)
COMMENT (댓글)
- COMMENT_ID (PK) — INT — Primary key — NOT NULL
- POST_ID (PK2) — INT — Foreign key → POST.POST_ID — NOT NULL
- CONTENT (Field) — VARCHAR(500)
- REG_DATE (Field2) — TIMESTAMP
FILE (파일)
- FILE_ID (PK) — INT — Primary key — NOT NULL
- POST_ID (PK2) — INT — Foreign key → POST.POST_ID — NOT NULL
- ORIG_NAME (Field) — VARCHAR(100)
- STORE_NAME (Field2) — VARCHAR(200)
- EXT (Field3) — VARCHAR(10)
- STORE_DIR (Field4) — VARCHAR(200)
POST (게시글)
- POST_ID (PK) — INT — Primary key — NOT NULL
- CATEGORY_ID (PK2) — INT — Foreign key → CATEGORY.CATEGORY_ID — NOT NULL
- TITLE (Field) — VARCHAR(100)
- WRITER (Field2) — CHAR(5)
- CONTENT (Field4) — VARCHAR(2000)
- HIT (Field5) — INT
- REG_DATE (Field6) — TIMESTAMP
- MOD_DATE (Field7) — TIMESTAMP
- SALT (Field8) — VARCHAR(32)
- HASH (Field9) — VARCHAR(64)