과제-공유-김정민

테이블 (4)

Space (Untitled2)

  • id (Key) — int — 기본 키 — NOT NULL
  • createUserId (Field7) — int
  • managerCode (Field) — varchar
  • participantCode (Field2) — varchar
  • name (Field5) — varchar
  • logoUrl (Field6) — varchar
  • createdAt (Field3) — timestamp
  • deletedAt (Field4) — timestamp

SpaceRole (Untitled4)

  • id (Key) — int — 기본 키 — NOT NULL
  • spaceId (Key2) — int — 외래 키 → Space.id — NOT NULL
  • rollType (Field) — enum
  • name (Field2) — varchar
  • createdAt (Field3) — timestamp
  • deletedAt (Field4) — timestamp

User (Untitled)

  • id — int — 기본 키 — NOT NULL
  • email (Field) — varchar
  • password (Field2) — varchar
  • firstName (Field3) — varchar
  • laskName (Field4) — varchar
  • pictureUrl (Field5) — varchar
  • createdAt (Field6) — timestamp
  • deletedAt (Field7) — timestamp

UserJoinSpace (Untitled3)

  • userId (id) — int — 외래 키 → User.id — NOT NULL
  • spaceId (Key) — int — 외래 키 → Space.id — NOT NULL
  • spaceRollId (Key2) — int — 외래 키 → SpaceRole.id — NOT NULL
  • isOwner (Field) — boolean
  • joinedAt (Field2) — timestamp
  • deletedAt (Field3) — timestamp