ELN_project

Tables (10)

Comment (Untitled4)

  • id (Key) — Primary key — NOT NULL
  • note_id (Key2) — Foreign key → Note.id — NOT NULL
  • user_id (Key3) — Foreign key → UserSupabase.UserUID — NOT NULL
  • created_at (Field2) — Datetime
  • updated_at (Field3) — Datetime
  • content (Field) — text

Gitrepo (Untitled6)

  • id (Key) — Primary key — NOT NULL
  • research_id (Key2) — Foreign key → Research.id — NOT NULL
  • created_at (Field2) — Datetime
  • updated_at (Field3) — Datetime
  • repo_url (Field) — Varchar

Note (Untitled9)

  • id (Key) — Primary key — NOT NULL
  • user_id (Key3) — Foreign key → UserSupabase.UserUID — NOT NULL
  • notebook_id (Key2) — Foreign key → Notebook.id — NOT NULL
  • created_at (Field2) — Datetime
  • updated_at (Field3) — Datetime
  • title (Field) — Varchar
  • timestamp_auth (Field4)
  • file_name (Field5) — Varchar
  • file_source_name (Field6) — Varchar
  • file_route (Field7) — Varchar
  • isGitrepo (Field8) — Bool

NoteTag (Untitled10)

  • Key — Primary key — NOT NULL
  • note_id (Key2) — Foreign key → Note.id — NOT NULL
  • tag_id (Key3) — Foreign key → Tag.id — NOT NULL

Notebook (Untitled3)

  • id (Key) — Primary key — NOT NULL
  • research_id (Key2) — Foreign key → Research.id — NOT NULL
  • created_at (Field2) — Datetime
  • updated_at (Field3) — Datetime
  • title (Field) — Varchar
  • isDefault (Field4) — Bool

Research (Untitled2)

  • id (Key) — Primary key — NOT NULL
  • PI_id (Key2) — Foreign key → UserSupabase.UserUID — NOT NULL
  • created_at (Field3) — Datetime
  • updated_at (Field4) — Datetime
  • title (Field) — Varchar
  • grant_number (Field2) — Varchar
  • isGithub (Field5) — Bool
  • isRemovable (Field6) — Bool
  • isDownloadable (Field7) — Bool

Tag (Untitled5)

  • id (Key) — Primary key — NOT NULL
  • created_at (Field2) — Datetime
  • updated_at (Field3) — Datetime
  • content (Field) — Varchar

UserPublic (Untitled)

  • id (Key) — Primary key — NOT NULL
  • UserUID (Key2) — Foreign key → UserSupabase.UserUID — NOT NULL
  • group (Field) — Varchar
  • sign_router (Field4) — Varchar
  • isPremium (Field2) — Bool
  • isAdmin (Field3) — Bool
  • billing_key (Field5) — Varchar
  • billing_expired_at (Field6) — Datetime

UserResearch (Untitled8)

  • Key — Primary key — NOT NULL
  • user_id (Key2) — Foreign key → UserSupabase.UserUID — NOT NULL
  • research_id (Key3) — Foreign key → Research.id — NOT NULL

UserSupabase (Untitled7)

  • UserUID (Key) — Primary key — NOT NULL
  • Email (Field1) — Varchar
  • Phone (Field2) — Varchar
  • Provider (Field3)
  • Created (Field4) — Datetime
  • LastSignIn (Field5) — Datetime