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