project
Tables (9)
Comment (Untitled3)
- id (Key) — Long — Primary key — NOT NULL
- userId (Key3) — Long — Foreign key → User.id — NOT NULL
- postId (Key2) — Long — Foreign key → Post.id — NOT NULL
- reelsId (Key4) — Long — Foreign key → Reels.id — NOT NULL
- communityId (Key5) — Long — Foreign key → Community.id — NOT NULL
- withPostId (Key6) — Long — Foreign key → WithPost.id — NOT NULL
- content (Field) — String
Community (Untitled5)
- id (Key) — Long — Primary key — NOT NULL
- userId (Key2) — Long — Foreign key → User.id — NOT NULL
- category (Field6) — Enum
- title (Field) — String
- img (Field2) — String
- content (Field3) — String
- likeCnt (Field4) — Long
- viewCnt (Field5) — Long
- createdAt (Field7) — Localtime
- modifiedAt (Field8) — Localtime
Notice (Untitled8)
- id (Key) — Long — Primary key — NOT NULL
- userId (Key2) — Long — Foreign key → User.id — NOT NULL
- title (Field) — String
- img (Field2) — String
- content (Field3) — String
- createdAt (Field4) — Localtime
- modifiedAt (Field5) — Localtime
People (Untitled9)
- id (Key) — Long — Primary key — NOT NULL
- withPostId (Key2) — Long — Foreign key → WithPost.id — NOT NULL
- userId (Key3) — Long — Foreign key → User.id — NOT NULL
- createdAt (Field) — Long
Post (Untitled2)
- id (Key) — Long — Primary key — NOT NULL
- userId (Key2) — Long — Foreign key → User.id — NOT NULL
- category (Field6) — Enum
- title (Field) — String
- img (Field2) — String
- content (Field3) — String
- likeCnt (Field4) — Long
- viewCnt (Field5) — Long
- createdAt (Field7) — Localtime
- modifiedAt (Field8) — Localtime
Reels (Untitled4)
- id (Key) — Long — Primary key — NOT NULL
- userId (Key2) — Long — Foreign key → User.id — NOT NULL
- category (Field6) — Enum
- title (Field) — String
- video (Field2) — String
- content (Field3) — String
- titleImg (Field7) — String
- likeCnt (Field4) — Long
- viewCnt (Field5) — Long
- createdAt (Field8) — Localtime
- modifiedAt (Field9) — Localtime
User (Untitled)
- id (Key) — Long — Primary key — NOT NULL
- email (Field) — String
- nickname (Field2) — String
- password (Field3) — String
- img (Field9) — String
- region (Field5) — String
- tier (Field6) — String
- exp (Field7) — Long
- role (Field4) — Enum
- createdAt (Field8) — Localtime
WithPost (Untitled6)
- id (Key) — Long — Primary key — NOT NULL
- userId (Key2) — Long — Foreign key → User.id — NOT NULL
- category (Field8) — Enum
- title (Field) — String
- content (Field2) — String
- img (Field3) — String
- date (Field12) — Localtime
- limitPeople (Field7) — Long
- location (Field6) — String
- peopleCnt (Field11) — Long
- likeCnt (Field4) — Long
- viewCnt (Field5) — Long
- createdAt (Field9) — Long
- modifiedAt (Field10) — Long
heart (Untitled7)
- id (Key) — Long — Primary key — NOT NULL
- userId (Key2) — Long — Foreign key → User.id — NOT NULL
- postId (Key3) — Long — Foreign key → Post.id — NOT NULL
- reelsId (Key4) — Long — Foreign key → Reels.id — NOT NULL
- communityId (Key5) — Long — Foreign key → Community.id — NOT NULL
- withPostId (Key6) — Long — Foreign key → WithPost.id — NOT NULL