minidooray

Tables (9)

milestone

    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

    tag

      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