issue
Tables (6)
admin (Untitled2)
- admin_id (Key) — Long — Primary key — NOT NULL
- password (Field) — String
- admin_code (Field2) — String
- group_code (Field3) — String
- name (Field4) — String
comment (Untitled6)
- c_id (Key) — Long — Primary key — NOT NULL
- title (Field) — String
- contents (Field2) — String
- issue_id (Key2) — Long — Foreign key → issue.issue_id — NOT NULL
issue (Untitled5)
- issue_id (Key) — Long — Primary key — NOT NULL
- description (Field) — String
- title (Field2) — String
- priority (Field3) — String
- state (Field4) — String
- p_id (Key2) — Long — Foreign key → project.p_id — NOT NULL
project (Untitled3)
- p_id (Key) — Long — Primary key — NOT NULL
- title (Field) — String
- admin_id (Key2) — Long — Foreign key → admin.admin_id — NOT NULL
users (Untitled)
- user_id (Key) — Long — Primary key — NOT NULL
- password (Field) — String
- group_code (Field2) — String
- name (Field3) — String
- Field4
users_project (Untitled4)
- user_id (Key2) — Long — Foreign key → users.user_id — NOT NULL
- p_id (Key) — Long — Foreign key → project.p_id — NOT NULL
- role_type (Field2) — String