QCS

Tables (16)

Customer (customer)

  • id — Primary key — NOT NULL
  • name — VARCHAR(50)

DesignKit (design_kit)

  • id — Primary key — NOT NULL
  • name — VARCHAR(200)
  • is_released — BOOLEAN
  • release_date — DATETIME
  • deleted_dt — DATETIME
  • subject_ip_id — Foreign key → SubjectIP.id — NOT NULL

DesignKitItem (design_kit_item)

  • id — Primary key — NOT NULL
  • name — VARCHAR(100)
  • status — VARCHAR(20)
  • is_approved — BOOLEAN
  • category — VARCHAR(200)
  • description — TEXT
  • deleted_dt — DATETIME
  • design_kit_id — Foreign key → DesignKit.id — NOT NULL

ItemAssignee (item_asignee)

  • id — Primary key — NOT NULL
  • design_kit_item_id — Foreign key → DesignKitItem.id — NOT NULL
  • user_id — Foreign key → User.id — NOT NULL

ItemComment (item_comment)

  • id — Primary key — NOT NULL
  • content — VARCHAR(1000)
  • is_deleted — BOOLEAN
  • design_kit_item_id — Foreign key → DesignKitItem.id — NOT NULL
  • user_id — Foreign key → User.id — NOT NULL

ItemContent (item_content)

  • id — Primary key — NOT NULL
  • content — TEXT
  • order — INT
  • design_kit_item_id — Foreign key → DesignKitItem.id — NOT NULL

ItemFile (item_file)

  • id — Primary key — NOT NULL
  • file_name — VARCHAR(500)
  • storage_path — VARCHAR(1000)
  • file_type
  • design_kit_item_id — Foreign key → DesignKitItem.id — NOT NULL

Schedule (schedule)

  • id — Primary key — NOT NULL
  • name — VARCHAR(200)
  • is_checked — BOOLEAN
  • type — VARCHAR(16)
  • date — DATE
  • note — TEXT
  • subject_id — Foreign key → Subject.id — NOT NULL

Subject (subject)

  • id — Primary key — NOT NULL
  • name — VARCHAR(50)
  • status — BOOLEAN
  • vendor — VARCHAR(50)
  • customer_id — Foreign key → Customer.id — NOT NULL

SubjectApprover (subject_approver)

  • id — Primary key — NOT NULL
  • subject_id — Foreign key → Subject.id — NOT NULL
  • user_id — Foreign key → User.id — NOT NULL

SubjectIP (subject_ip)

  • id — Primary key — NOT NULL
  • name — VARCHAR(100)
  • order — INT
  • deleted_dt — DATETIME
  • subject_id — Foreign key → Subject.id — NOT NULL

Template (template)

  • id — Primary key — NOT NULL
  • name — VARCHAR(200)
  • schema — JSONB

TemplateFile (template_file)

  • id — Primary key — NOT NULL
  • storage_path — VARCHAR(1000)
  • file_name — VARCHAR(500)
  • file_size_bytes — BIG INT
  • template_id — Foreign key → Template.id — NOT NULL

TemplateGroup (template_group)

  • id — Primary key — NOT NULL
  • name — VARCHAR(200)
  • sort_order — INT
  • template_id — Foreign key → Template.id — NOT NULL

TemplateItem (template_item)

  • id — Primary key — NOT NULL
  • name — VARCHAR(200)
  • description — VARCHAR(1000)
  • sort_order — INT
  • group_id — Foreign key → TemplateGroup.id — NOT NULL

User (user)

  • id — Primary key — NOT NULL
  • username — VARCHAR(30)
  • email — VARCHAR(100)
  • name — VARCHAR(20)
  • role — VARCHAR(20)