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