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`