doit-blog
Tables (5)
Category (Untitled4)
- categoryId (Key) — Long — Primary key — NOT NULL
- type (Field) — Enum
- createdAt (Field2) — DateTime
- modifiedAt (Field3) — DateTime
Comment (Untitled2)
- commentId (Key) — Long — Primary key — NOT NULL
- content (Field) — String
- createdAt (Field3) — DateTime
- modifiedAt (Field4) — DateTime
- postId (Key2) — Long — Foreign key → Post.postId — NOT NULL
- userId (Key3) — Long — Foreign key → User.userId — NOT NULL
Post (Untitled)
- postId (Key) — Long — Primary key — NOT NULL
- title (Field) — String
- content (Field2) — String
- image (Field6) — String
- likeCount (Field3) — Integer
- createdAt (Field4) — DateTime
- modifiedAt (Field5) — DateTime
- userId (Key2) — Long — Foreign key → User.userId — NOT NULL
- categoryId (Key3) — Long — Foreign key → Category.categoryId — NOT NULL
User (유저)
- userId (Key) — Long — Primary key — NOT NULL
- name (Field) — String
- loginId (Field2) — String
- nickname (Field7) — String
- password (Field3) — String
- phoneNumber (Field4) — String
- createdAt (Field5) — DateTime
- modifiedAt (Field6) — DateTime
UserLikePost (Untitled3)
- userLikePostId (Key) — Long — Primary key — NOT NULL
- createdAt (Field) — DateTime
- modifiedAt (Field2) — DateTime
- userId (Key2) — Long — Foreign key → User.userId — NOT NULL
- postId (Key3) — Long — Foreign key → Post.postId — NOT NULL