minidooray
Tables (9)
oauth
- oauth_code (Key) — NOT NULL — Primary key — NOT NULL
- name (Field) — NOT NULL
project
- project_id (Key) — NOT NULL — Primary key — NOT NULL
- title (Field) — NOT NULL
- created_at (Field2) — NOT NULL
- modify_at (Field3) — NOT NULL
- description (Field4) — NOT NULL
- Field5
project_role
- project_role_code (Key) — NOT NULL — Primary key — NOT NULL
- name (Field) — NOT NULL
role
- role_code (Key) — NOT NULL — Primary key — NOT NULL
- name (Field) — NOT NULL
task
- task_id (Key) — NOT NULL — Primary key — NOT NULL
- Field
user
- user_id (Key) — NOT NULL — Primary key — NOT NULL
- role_code (Key3) — NOT NULL — Foreign key → role.role_code — NOT NULL
- oauth_code (Key2) — NOT NULL — Foreign key → oauth.oauth_code — NOT NULL
- name (Field) — NOT NULL
- login_id (Field2) — NOT NULL
- password (Field3) — NOT NULL
- email (Field4) — NOT NULL
- created_at (Field5) — NOT NULL
- modify_at (Field6) — NOT NULL
- last_login_at (Field7) — NOT NULL
user_project (Untitled)
- user_project_id (Key4) — NOT NULL — Primary key — NOT NULL
- user_id (Key) — NOT NULL — Foreign key → user.user_id — NOT NULL
- project_id (Key2) — NOT NULL — Foreign key → project.project_id — NOT NULL
- project_role_code (Key3) — NOT NULL — Foreign key → project_role.project_role_code — NOT NULL