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