notionary

Tables (11)

category

  • category_id — INT — Primary key — NOT NULL
  • category_name — VARCHAR(20) — NOT NULL
  • depth — INT — NOT NULL
  • category_id_fk — INT — Foreign key → category.category_id
  • INDEX — `category_id_fk`

comment

  • id — INT — Primary key — NOT NULL
  • uid — VARCHAR(20) — Foreign key → user.uid — NOT NULL
  • post_id — INT — Foreign key → post.post_id — NOT NULL
  • category_id — INT — NOT NULL
  • content — VARCHAR(200) — NOT NULL
  • createdAt — DATETIME — NOT NULL
  • updatedAt — DATETIME — NOT NULL
  • INDEX — `uid`
  • INDEX — `post_id`

heart

  • post_id — INT — Foreign key → post.post_id — NOT NULL
  • uid — VARCHAR(20) — Foreign key → user.uid — NOT NULL
  • INDEX — `uid`

myproject

  • project_id — INT — Primary key — NOT NULL
  • uid — VARCHAR(20) — Foreign key → user.uid — NOT NULL
  • txtFilePath — VARCHAR(100) — NOT NULL
  • project_name — VARCHAR(50) — NOT NULL
  • createdAt — DATETIME — NOT NULL
  • updatedAt — DATETIME — NOT NULL
  • INDEX — `uid`

page

  • Page_name — VARCHAR(120) — Primary key — NOT NULL
  • workspace_id — INT — NOT NULL
  • page_content — TEXT
  • createdAt — DATETIME — NOT NULL
  • updatedAt — DATETIME — NOT NULL
  • fk_workspace_id — INT — Foreign key → workspacectgrs.workspace_id
  • INDEX — `fk_workspace_id`

post

  • post_id — INT — Primary key — NOT NULL
  • uid — VARCHAR(20) — Foreign key → user.uid — NOT NULL
  • category_id — INT — Foreign key → category.category_id — NOT NULL
  • fk_workspace_id — INT — Foreign key → workspacectgrs.workspace_id
  • workspace_pages — VARCHAR(50)
  • title — VARCHAR(50) — NOT NULL
  • imgPaths — VARCHAR(1000) — NOT NULL
  • videoPaths — VARCHAR(1000) — NOT NULL
  • content — VARCHAR(200) — NOT NULL
  • createdAt — DATETIME — NOT NULL
  • updatedAt — DATETIME — NOT NULL
  • INDEX — `uid`
  • INDEX — `category_id`
  • INDEX — `fk_workspace_id`

team

  • project_id — INT — Foreign key → teamproject.project_id — NOT NULL
  • uid — VARCHAR(20) — Foreign key → user.uid — NOT NULL
  • INDEX — `uid`

teamproject

  • project_id — INT — Primary key — NOT NULL
  • uid — VARCHAR(20) — Foreign key → user.uid — NOT NULL
  • txtFilePath — VARCHAR(100) — NOT NULL
  • project_name — VARCHAR(50) — NOT NULL
  • createdAt — DATETIME — NOT NULL
  • updatedAt — DATETIME — NOT NULL
  • INDEX — `uid`

user

  • uid — VARCHAR(20) — Primary key — NOT NULL
  • upw — VARCHAR(100) — NOT NULL
  • nick — VARCHAR(20) — NOT NULL
  • gender — VARCHAR(10)
  • phone — VARCHAR(20)
  • dob — VARCHAR(20)
  • addr — VARCHAR(100)
  • profImg — VARCHAR(500)
  • createdAt — DATETIME — NOT NULL
  • updatedAt — DATETIME — NOT NULL

workspace

  • workspace_name — VARCHAR(120) — Primary key — NOT NULL
  • createdAt — DATETIME — NOT NULL
  • updatedAt — DATETIME — NOT NULL

workspacectgrs

  • workspace_id — INT — Primary key — NOT NULL
  • uid — VARCHAR(20) — Foreign key → user.uid — NOT NULL
  • workspace_name — VARCHAR(120) — NOT NULL
  • workspacectgrs_name — VARCHAR(120)
  • workspacesubctgrs_name — VARCHAR(120)
  • depth — INT — NOT NULL
  • parent_id — VARCHAR(120)
  • createdAt — DATETIME — NOT NULL
  • updatedAt — DATETIME — NOT NULL
  • fk_workspace_id — INT — Foreign key → workspacectgrs.workspace_id
  • fk_workspace_name — VARCHAR(120) — Foreign key → workspace.workspace_name
  • INDEX — `fk_workspace_id`
  • INDEX — `fk_workspace_name`