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