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