Welog

Tables (7)

Board

  • boardId (Key) — int — Primary key — NOT NULL
  • content (Field) — String
  • title (Field2) — String
  • version (Field3) — String
  • category (Field4) — String
  • auth (Field5) — String

BookMark (BookMard)

  • BookMarkId (Key3) — Primary key — NOT NULL
  • userId (Key) — int — Foreign key → User.userId — NOT NULL
  • boardId (Key2) — int — Foreign key → Board.boardId — NOT NULL

Comment

  • commentId (Key2) — int — Primary key — NOT NULL
  • content (Field) — String
  • parentId (Field2) — int
  • line (Field3) — int
  • boardId (Key) — int — Foreign key → Board.boardId — NOT NULL
  • registerDay (Field4) — Date

User

  • userId (Key) — int — Primary key — NOT NULL
  • userName (Field) — String
  • userEmail (Field3) — String
  • role (Field2) — String

UserBoard

  • userBoardId (Key) — int — Primary key — NOT NULL
  • userId (Key2) — int — Foreign key → User.userId — NOT NULL
  • boardId (Key3) — int — Foreign key → Board.boardId — NOT NULL

UserComment

  • Key — int — Primary key — NOT NULL
  • Key2 (Key22) — int — Foreign key → Comment.commentId — NOT NULL
  • Key (Key2) — int — Foreign key → User.userId — NOT NULL

feel

  • feelId (Key) — Primary key — NOT NULL
  • userId (Key2) — int — Foreign key → User.userId — NOT NULL
  • commentId (Key22) — int — Foreign key → Comment.commentId — NOT NULL
  • feeling — String