board

Tables (6)

Board (Untitled4)

  • boardId (Key) — bigint — Primary key — NOT NULL
  • name (Field) — varchar2(10) — NOT NULL

Comment (Untitled5)

  • commentId (Key) — bigint — Primary key — NOT NULL
  • userId (Key2) — varchar2(30) — Foreign key → User.userId — NOT NULL
  • postId (Key3) — bigint — Foreign key → Post.postId — NOT NULL
  • content (Field) — text — NOT NULL
  • createdAt (Field2) — timestamp — NOT NULL
  • updatedAt (Field3) — timestamp — NOT NULL

Like (Untitled3)

  • userId (Key) — varchar2(30) — Foreign key → User.userId — NOT NULL
  • postId (Key2) — bigint — Foreign key → Post.postId — NOT NULL
  • isLiked (Field) — boolean — NOT NULL
  • createdAt (Field2) — timestamp — NOT NULL
  • updateAt (Field3) — timestamp — NOT NULL

Post (Untitled2)

  • postId (Key) — bigint — Primary key — NOT NULL
  • boardId (Key3) — bigint — Foreign key → Board.boardId — NOT NULL
  • title (Field) — varchar2(30) — NOT NULL
  • createdAt (Field2) — timestamp — NOT NULL
  • updatedAt (Field8) — timestamp — NOT NULL
  • content (Field3) — text — NOT NULL
  • hit (Field4) — int — NOT NULL
  • userId (Key2) — varchar2(30) — Foreign key → User.userId — NOT NULL

User (Untitled)

  • userId (Key) — varchar2(30) — Primary key — NOT NULL
  • password (Field) — varchar2(100) — NOT NULL
  • email (Field2) — varchar2(20) — NOT NULL
  • name (Field3) — varchar2(10) — NOT NULL
  • birthday (Field4) — date
  • grade (Field5) — varchar2(10) — NOT NULL

file (Untitled6)

  • fileID (Key) — bigint — Primary key — NOT NULL
  • postId (Key2) — bigint — Foreign key → Post.postId — NOT NULL
  • fileURL (Field) — varchar2(100) — NOT NULL
  • fileSize (Field2) — bigint — NOT NULL
  • order (Field3) — int — NOT NULL