DropBox
Tables (7)
Code (Untitled2)
- num (Key) — NOTNULL — Primary key — NOT NULL
Comment (Untitled5)
- id (Key) — NOTNULL — Primary key — NOT NULL
- ownerId (Key2) — NOTNULL — Foreign key → User.id — NOT NULL
- fileId (Key3) — NOTNULL — Foreign key → File.id — NOT NULL
- content (Field1) — NOTNULL
- createdAT (Field2) — NOTNULL
- updatedAt (Field3) — NOTNULL
- deletedAt (Field4) — NOTNULL
- Key2 (Key22) — Foreign key — NOT NULL
File (Untitled4)
- id (Key) — NOTNULL — Primary key — NOT NULL
- folderId (Key2) — NULL — Foreign key → Folder.id — NOT NULL
- ownerId (Key4) — NOTNULL — Foreign key → User.id — NOT NULL
- teamId (Key3) — NOTNULL — Foreign key → Team.id — NOT NULL
- fileUrl (Field6) — NOTNULL
- name (Field4) — NOTNULL
- createdAt (Field) — NOTNULL
- updatedAt (Field2) — NOTNULL
- deletedAt (Field3) — NULL
- favorate (Field5) — NOTNULL
Folder (User)
- id (Key) — NOTNULL — Primary key — NOT NULL
- ownerId (Key2) — NOTNULL — Foreign key → User.id — NOT NULL
- codeNumber (Key4) — NOTNULL — Foreign key → Code.num — NOT NULL
- teamId (Key3) — NOTNULL — Foreign key → Team.id — NOT NULL
- name (Field) — NOTNULL
- hierarchy (Field5) — NOTNULL
- createdAt (Field3) — NOTNULL
- updatedAt (Field4) — NOTNULL
- deletedAt (Field2) — NULL
Team (Untitled6)
- id (Key) — NOTNULL — Primary key — NOT NULL
- name (Field) — NOTNULL
- createdAt (Field2) — NOTNULL
- intro (Field3) — NULL
- imgUrl (Field4) — NOTNULL
User (Untitled)
- id (Key) — NOTNULL — Primary key — NOT NULL
- email (Field) — NOTNULL
- nickname (Field2) — NULL
- password (Field3) — NULL
- imgUrl (Field4) — NULL
- provider (Field5) — NULL
- authId (Field6) — NULL
- createdAt (Field7) — NOTNULL
User_Team (Untitled7)
- teamId (Key) — NOTNULL — Foreign key → Team.id — NOT NULL
- userId (Key2) — NOTNULL — Foreign key → User.id — NOT NULL
- rank (Field) — NOTNULL
- createdAT (Field2) — NOTNULL
- updatedAt (Field3) — NOTNULL