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

unknown