ㄴㄴㄴㄴ
Tables (8)
BLOG_Board
- BRDNO — NUMBER — Primary key — NOT NULL
- BNO — NUMBER — Foreign key → BLOG_INFO.BNO — NOT NULL
- CNAME — VARCHAR(50)
- BOARD — SUBJECT"
- CONTENT — CLOB
- DATE — DATE
- HIT — NUMBER
BLOG_CATEGORY
- CNAME — VARCHAR(50)
- BNO — NUMBER — Foreign key → BLOG_INFO.BNO — NOT NULL
- BLOG_INDEX — NUMBER(10)
BLOG_COMMENT
- CMTNo — NUMBER — Primary key — NOT NULL
- BRDNo — NUMBER — NOT NULL
- CMTBasicSet — NUMBER(1)
- cmtMid — VARCHAR(50)
- cmtDate — DATE
- cmtContent — VARCHAR(500)
- cmtRepl — NUMBER
BLOG_INFO
- BNO — NUMBER — Primary key — NOT NULL
- ID — VARCHAR(50) — NOT NULL
- BLOGTITLE — VARCHAR(50)
- nName — VARCHAR(50)
- mPhoto — VARCHAR(100)
BOARD_LIKE
- LIKENO — NUMBER — Primary key — NOT NULL
- BRDNO — NUMBER — Foreign key → BLOG_Board.BRDNO — NOT NULL
- LIKEID — INT — Foreign key → USER.ID — NOT NULL
FILES
- FILENO — NUMBER — Primary key — NOT NULL
- BRDNO — NUMBER — Foreign key → BLOG_Board.BRDNO — NOT NULL
- CName — VARCHAR(50)
- FILEName — VARCHAR(100)
TAG
- TNO — NUMBER — Primary key — NOT NULL
- BRDNO — NUMBER — Foreign key → BLOG_Board.BRDNO — NOT NULL
- T_CONTENT — VARCHAR(2000)
USER
- ID — INT — Foreign key — NOT NULL
- PASSWORD — VARCHAR(30)
- NAME — VARCHAR(30)
- NICKNAME — VARCHAR(10)
- PROFILE_IMAGE — VARCHAR2(100)