Rocket

Tables (7)

Group (Untitled)

  • id (Key) — Long — Primary key — NOT NULL
  • Field

Like (Untitled4)

    Membership (Untitled5)

      Photo (Untitled3)

        Post (Untitled2)

          User (users)

          • id (Key) — Long — Primary key — NOT NULL
          • joinedGroupId (Field10) — Long
          • createdGroupId (Field11) — Long
          • email (UNIQUE) — varchar(50) — NOT NULL
          • password (Field2) — varchar(50)
          • Nickname (Field3) — varchar(50)
          • location (Field) — varchar(20)
          • profile_url (Field4) — varchar(500)
          • mannerScore (Field7) — Bigint
          • status (Field8) — Enum(String)
          • created_at (Field5) — timestamp
          • role (Field9) — Enum(String)
          • updated_at (Field6) — timestamp
          • address (Field12) — Address

          User_Group (Untitled6)

          • id (Key) — Long — Primary key — NOT NULL
          • user_id (FK) — Long
          • group_id (FK2) — Long
          • Field