Blog
Tables (3)
Board
- boardID — INT — Primary key — NOT NULL
- userID — INT — Foreign key → User.userID — NOT NULL
- title — VARCHAR2(100)
- content — VARCHAR2(1000)
- count — INT
- createDate — Timestamp
Reply
- replyID — INT — Primary key — NOT NULL
- userID — INT — Foreign key → User.userID — NOT NULL
- boardID — INT — Foreign key → Board.boardID — NOT NULL
- content — VARCHAR2(200)
- createDate — Timestamp
User
- userID — INT — Primary key — NOT NULL
- username — VARCHAR2(30)
- password — VARCHAR2(100)
- email — VARCHAR2(50)
- role — VARCHAR2(20)
- createDate — Timestamp