Cldong
Tables (5)
board_tb (게시글)
- bId — VARCHAR — Primary key — NOT NULL
- uId — VARCHAR — Foreign key → user_tb.uId — NOT NULL
- vId — VARCHAR — Foreign key → video_tb.vId — NOT NULL
- modDate — DATETIME
- regDate — DATETIME
- bTitle — VARCHAR
- bContent — VARCHAR
log_tb (로그)
- lId — VARCHAR — Primary key — NOT NULL
- bId — VARCHAR — Foreign key → board_tb.bId — NOT NULL
- uId — VARCHAR — Foreign key → board_tb.uId — NOT NULL
reply_tb (댓글)
- rId — VARCHAR — Primary key — NOT NULL
- bId — VARCHAR — Foreign key → board_tb.bId — NOT NULL
- uId — VARCHAR — Foreign key → user_tb.uId — NOT NULL
- content — VARCHAR
- regDate — DATETIME
- modDate — DATETIME
user_tb (회원)
- uId — VARCHAR — Primary key — NOT NULL
- password — VARCHAR
- nickname — VARCHAR
- email — VARCHAR
- regDate — DATETIME
- modDate — DATETIME
- rol — VARCHAR
video_tb (비디오)
- vId — VARCHAR — Primary key — NOT NULL
- orgn — VARCHAR
- name — VARCHAR
- vol — VARCHAR
- tag — VARCHAR
- regDate — DATETIME
- size — VARCHAR