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)