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