asd
Tables (8)
PROFILE
- profile_id — bigint
- user_id — bigint — NOT NULL
- avatar_url — varchar(255)
- introduction — varchar(500)
PROJECT
- project_id — BIGINT
- owner_user_id — BIGINT — NOT NULL
- custom_url — VARCHAR(15) — NOT NULL
- banner_url — VARCHAR(255) — NOT NULL
- name — VARCHAR(100) — NOT NULL
- detail — TEXT — NOT NULL
- due_date — DATETIME — NOT NULL
- created — DATETIME — NOT NULL
- is_public — TINYINT(1) — NOT NULL
PROJECT_MEMBER
- project_member_id — BIGINT
- project_id — BIGINT — NOT NULL
- user_id — BIGINT — NOT NULL
PROJECT_TAG
- project_tag_id — BIGINT
- project_id — BIGINT — NOT NULL
- tag — VARCHAR(100) — NOT NULL
- hex_code — VARCHAR — NOT NULL
USER
- user_id — bigint
- nickname — varchar(20) — NOT NULL
- is_online — varchar(10) — NOT NULL
- email — varchar(100) — NOT NULL
- password — varchar(200) — NOT NULL
status_tag
- status_tag_id — VARCHAR(100)
- hex_code — VARCHAR(8) — NOT NULL
task
- task_id — BIGINT
- creator_user_id — BIGINT — NOT NULL
- status_tag_id — VARCHAR(100) — Foreign key → status_tag.status_tag_id — NOT NULL
- taskname — VARCHAR(100) — NOT NULL
- detail — TEXT — NOT NULL
- due_date — DATETIME — NOT NULL
- created — DATETIME — NOT NULL