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