board-project
Tables (5)
BBS_BOARD
- B_ID — PRIMARY KEY — Primary key — NOT NULL
- Key (B_WRITER) — NOT NULL — Foreign key → BBS_USER.Key — NOT NULL
- Field (B_WRITE_DATE) — NOT NULL
- Field2 (B_UPDATE_DATE) — NOT NULL
- Field3 (B_SUBJECT) — NOT NULL
- Field4 (B_CONTENT)
- Field (B_VIEWS)
- Field (B_RECOMMEND)
- Field (B_REPLY_COUNT)
BBS_RECOMMEND
- Key (R_ID) — PRIMARY KEY — Primary key — NOT NULL
- Key (R_USERID) — NOT NULL — Foreign key → BBS_USER.Key — NOT NULL
- B_ID (R_B_ID) — NOT NULL — Foreign key → BBS_BOARD.B_ID — NOT NULL
- Field (R_DATE) — NOT NULL
BBS_USER
- Key (USERID) — PRIMARY KEY — Primary key — NOT NULL
- Field (UWERPW) — NOT NULL
- Field (REG_DATE) — NOT NULL
- Field (UPDATE_DATE)
- Field (ENABLED)
Copy Of BBS_BOARD (BBS_COMMENT)
- B_ID (C_ID) — PRIMARY KEY — Primary key — NOT NULL
- B_ID (C_B_ID) — NOT NULL — Foreign key → BBS_BOARD.B_ID — NOT NULL
- Field2 (C_P_ID)
- Key (C_WRITER) — NOT NULL — Foreign key → BBS_USER.Key — NOT NULL
- Field3 (C_WRITE_DATE) — NOT NULL
- Field (C_COMMENT) — NOT NULL
Untitled (BBS_USER_AUTH)
- Key (USERID) — PRIMARY KEY — Foreign key → BBS_USER.Key — NOT NULL
- Field (AUTH) — NOT NULL