과제-공유-김정민
테이블 (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