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