DIVA

Tables (16)

DATA_TYPE

  • type_id — INT — Primary key — NOT NULL
  • type_name — VARCHAR(32) — NOT NULL

MEMBERSHIP

  • membership_id — INT — Primary key — NOT NULL
  • membership_name — VARCHAR(32) — NOT NULL

ORGANIZATION

  • org_id — INT — Primary key — NOT NULL
  • org_email — VARCHAR(32) — NOT NULL
  • org_name — VARCHAR(32) — NOT NULL
  • creator_id — VARCHAR(32) — Foreign key → USER.user_id — NOT NULL
  • created — datetime — NOT NULL
  • updated — datetime — NOT NULL

PROJECT

  • project_id — INT — Primary key — NOT NULL
  • project_type — INT — Foreign key → PROJECT_TYPE.project_type_id — NOT NULL
  • project_name — VARCHAR(32) — NOT NULL
  • data_type — INT — Foreign key → DATA_TYPE.type_id — NOT NULL
  • desc — TEXT
  • created — datetime — NOT NULL
  • updated — datetime — NOT NULL

PROJECT_TYPE

  • project_type_id — INT — Primary key — NOT NULL
  • type_name — VARCHAR(32) — NOT NULL
  • desc — TEXT

ROLE

  • role_id — INT — Primary key — NOT NULL
  • role_name — VARCHAR(32) — NOT NULL
  • role_desc — TEXT

SOCIAL_PLATFORM_TYPE

  • provider_id — INT — Primary key — NOT NULL
  • provider_name — VARCHAR(32) — NOT NULL

SYSTEM

  • version — INT — Primary key — NOT NULL
  • info — VARCHAR(32)
  • created — datetime — NOT NULL
  • updated — datetime — NOT NULL

TEAM

  • team_id — INT — Primary key — NOT NULL
  • team_name — VARCHAR(32) — NOT NULL
  • team_info — VARCHAR(32)
  • created — datetime — NOT NULL
  • updated — datetime — NOT NULL

TEAM_PROJECTS

  • team_id — INT — Foreign key → TEAM.team_id — NOT NULL
  • project_id — INT — Foreign key → PROJECT.project_id — NOT NULL

USER

  • user_id — VARCHAR(32) — Primary key — NOT NULL
  • user_type_id — INT — Foreign key → USER_TYPE.user_type_id — NOT NULL
  • user_pw — VARCHAR(32)
  • social_id — VARCHAR(128)
  • email — VARCHAR(128) — NOT NULL
  • provider — INT — Foreign key → SOCIAL_PLATFORM_TYPE.provider_id
  • name — VARCHAR(32)
  • membership_id — INT — Foreign key → MEMBERSHIP.membership_id — NOT NULL
  • org_id — INT — Foreign key → ORGANIZATION.org_id
  • created — datetime — NOT NULL
  • updated — datetime — NOT NULL

USER_PROJECT_ROLES

  • user_id — VARCHAR(32) — Foreign key → USER.user_id — NOT NULL
  • role_id — INT — Foreign key → ROLE.role_id — NOT NULL
  • project_id — INT — Foreign key → PROJECT.project_id — NOT NULL

USER_TEAMS

  • user_id — VARCHAR(32) — Foreign key → USER.user_id — NOT NULL
  • team_id — INT — Foreign key → TEAM.team_id — NOT NULL

USER_TYPE

  • user_type_id — INT — Primary key — NOT NULL
  • type_name — VARCHAR(32) — NOT NULL

WORKSPACE

  • workspace_id — INT — Primary key — NOT NULL
  • creator_id — VARCHAR(32) — Foreign key → USER.user_id — NOT NULL
  • org_id — INT — Foreign key → ORGANIZATION.org_id
  • workspace_name — VARCHAR(32) — NOT NULL
  • workspcae_info — TEXT — NOT NULL
  • invitation_link — VARCHAR(128) — NOT NULL
  • workspace_info — VARCHAR(128)
  • created — datetime — NOT NULL
  • updated — datetime — NOT NULL

WORKSPACE_TEAMS

  • workspace_id — INT — Foreign key → WORKSPACE.workspace_id — NOT NULL
  • team_id — INT — Foreign key → TEAM.team_id — NOT NULL