e21
Tables (5)
Board
- BoardNo — number — Primary key — NOT NULL
- Title — varchar2 — NOT NULL
- Context — varchar2 — NOT NULL
- Writer — date — NOT NULL
- Date — date — NOT NULL
- BoardType — varchar2 — NOT NULL
- Recommend_Count — number — NOT NULL
- Read_Count — number — NOT NULL
- Report_Count — number — NOT NULL
- Del_Gb — varchar2 — NOT NULL
File
- FileNo — VARCHAR(255) — Primary key — NOT NULL
- BoardNo — number — Foreign key → Board.BoardNo — NOT NULL
- File_Name — VARCHAR(255)
- File_Size — VARCHAR(255)
- File_Path — VARCHAR(255)
Follow
- userNo — number — Foreign key → User.userNo — NOT NULL
Reply
- ComNo — VARCHAR(255) — Primary key — NOT NULL
- BoardNo — number — Foreign key → Board.BoardNo — NOT NULL
- Writer — VARCHAR(255) — NOT NULL
- Date — VARCHAR(255) — NOT NULL
- Context — VARCHAR(255) — NOT NULL
- Recommend_Count — VARCHAR(255) — NOT NULL
- Del_Gb — VARCHAR(255) — NOT NULL
User
- userNo — number — Primary key — NOT NULL
- Email — varchar2 — NOT NULL
- Password — varchar2 — NOT NULL
- NickName — varchar2 — NOT NULL
- Report_Count — number — NOT NULL
- Del_Gb — varchar2 — NOT NULL
- User_stop — varchar2 — NOT NULL
- Active_Score — varchar2 — NOT NULL
- Date — date — NOT NULL
- Admin — varchar2 — NOT NULL