TEST
Tables (60)
admin_filegroup
- group_id — bigint — Primary key — NOT NULL
- permission_level — varchar(500)
- app_label — varchar(500)
- model_name — varchar(500)
- one_file_yn — varchar(1) — NOT NULL
- explain_text — varchar(50)
- save_id — varchar(100) — NOT NULL
- reg_datetime — datetime(6) — NOT NULL
- mdf_datatime — datetime(6)
- del_datatime — datetime(6)
- del_yn — varchar(1) — NOT NULL
- multirow_yn — varchar(1) — NOT NULL
admin_files
- fileID — int — Primary key — NOT NULL
- file — varchar(100) — NOT NULL
- filename — varchar(500) — NOT NULL
- filesize — bigint — NOT NULL
- file_ext — varchar(10)
- reg_dttm — varchar(16) — NOT NULL
- reg_username — varchar(50) — NOT NULL
- save_id — varchar(100) — NOT NULL
- file_memo — varchar(200)
- reg_datetime — datetime(6) — NOT NULL
- mdf_datatime — datetime(6) — NOT NULL
- del_datatime — datetime(6) — NOT NULL
- del_yn — varchar(1) — NOT NULL
- row_explain — varchar(50)
- filegroup — bigint — Foreign key → admin_filegroup.group_id — NOT NULL
auth_group
- id — int — Primary key — NOT NULL
- name — varchar(150) — NOT NULL
auth_group_permissions
- id — int — Primary key — NOT NULL
- group_id — int — Foreign key → auth_group.id — NOT NULL
- permission_id — int — Foreign key → auth_permission.id — NOT NULL
auth_permission
- id — int — Primary key — NOT NULL
- name — varchar(255) — NOT NULL
- content_type_id — int — Foreign key → django_content_type.id — NOT NULL
- codename — varchar(100) — NOT NULL
common_files
- fileID — int — Primary key — NOT NULL
- file — varchar(100) — NOT NULL
- filename — varchar(500) — NOT NULL
- filesize — bigint — NOT NULL
- file_ext — varchar(10)
- reg_dttm — varchar(16) — NOT NULL
- reg_username — varchar(50) — NOT NULL
- save_id — varchar(100) — NOT NULL
- file_memo — varchar(200)
- reg_datetime — datetime(6) — NOT NULL
- mdf_datatime — datetime(6) — NOT NULL
- del_datatime — datetime(6)
- del_yn — varchar(1) — NOT NULL
- filegroup — bigint — Foreign key → commons_filegroup.group_id — NOT NULL
- row_explain — varchar(50)
common_files2
- fileID — int — Primary key — NOT NULL
- file — varchar(100) — NOT NULL
- filename — varchar(500) — NOT NULL
- reg_dttm — varchar(16) — NOT NULL
- reg_username — varchar(50) — NOT NULL
- save_id — varchar(100) — NOT NULL
- del_datatime — datetime(6) — NOT NULL
- del_yn — varchar(1) — NOT NULL
- file_ext — varchar(10)
- file_memo — varchar(200)
- filesize — bigint — NOT NULL
- mdf_datatime — datetime(6) — NOT NULL
- reg_datetime — datetime(6) — NOT NULL
commons_filegroup
- group_id — bigint — Primary key — NOT NULL
- company_id — bigint
- user_id — bigint
- permission_level — varchar(500)
- app_label — varchar(500)
- model_name — varchar(500)
- one_file_yn — varchar(1) — NOT NULL
- explain_text — varchar(50)
- save_id — varchar(100) — NOT NULL
- reg_datetime — datetime(6) — NOT NULL
- mdf_datatime — datetime(6)
- del_datatime — datetime(6)
- del_yn — varchar(1) — NOT NULL
- multirow_yn — varchar(1) — NOT NULL
django_admin_log
- id — int — Primary key — NOT NULL
- action_time — datetime(6) — NOT NULL
- object_id — longtext
- object_repr — varchar(200) — NOT NULL
- action_flag — smallint — NOT NULL
- change_message — longtext — NOT NULL
- content_type_id — int — Foreign key → django_content_type.id
- user_id — int — Foreign key → tcustomuser.userID — NOT NULL
django_content_type
- id — int — Primary key — NOT NULL
- app_label — varchar(100) — NOT NULL
- model — varchar(100) — NOT NULL
django_migrations
- id — int — Primary key — NOT NULL
- app — varchar(255) — NOT NULL
- name — varchar(255) — NOT NULL
- applied — datetime(6) — NOT NULL
django_session
- session_key — varchar(40) — Primary key — NOT NULL
- session_data — longtext — NOT NULL
- expire_date — datetime(6) — NOT NULL
partnership_info
- infoID — int — Primary key — NOT NULL
- contactComName — varchar(30) — NOT NULL
- contactName — varchar(10) — NOT NULL
- contactEmail — varchar(50) — NOT NULL
- contactPhone — varchar(15) — NOT NULL
- contactSubject — varchar(300) — NOT NULL
- contactMessage — varchar(300) — NOT NULL
- reg_dttm — varchar(16)
- reg_dt — varchar(8)
silk_profile
- id — int — Primary key — NOT NULL
- name — varchar(300) — NOT NULL
- start_time — datetime(6) — NOT NULL
- end_time — datetime(6)
- time_taken — double
- file_path — varchar(300) — NOT NULL
- line_num — int
- end_line_num — int
- func_name — varchar(300) — NOT NULL
- exception_raised — tinyint(1) — NOT NULL
- dynamic — tinyint(1) — NOT NULL
- request_id — varchar(36) — Foreign key → silk_request.id
silk_profile_queries
- id — int — Primary key — NOT NULL
- profile_id — int — Foreign key → silk_profile.id — NOT NULL
- sqlquery_id — int — Foreign key → silk_sqlquery.id — NOT NULL
silk_request
- id — varchar(36) — Primary key — NOT NULL
- path — varchar(190) — NOT NULL
- query_params — longtext — NOT NULL
- raw_body — longtext — NOT NULL
- body — longtext — NOT NULL
- method — varchar(10) — NOT NULL
- start_time — datetime(6) — NOT NULL
- view_name — varchar(190)
- end_time — datetime(6)
- time_taken — double
- encoded_headers — longtext — NOT NULL
- meta_time — double
- meta_num_queries — int
- meta_time_spent_queries — double
- pyprofile — longtext — NOT NULL
- num_sql_queries — int — NOT NULL
- prof_file — varchar(300) — NOT NULL
silk_response
- id — varchar(36) — Primary key — NOT NULL
- status_code — int — NOT NULL
- raw_body — longtext — NOT NULL
- body — longtext — NOT NULL
- encoded_headers — longtext — NOT NULL
- request_id — varchar(36) — Foreign key → silk_request.id — NOT NULL
silk_sqlquery
- id — int — Primary key — NOT NULL
- query — longtext — NOT NULL
- start_time — datetime(6)
- end_time — datetime(6)
- time_taken — double
- traceback — longtext — NOT NULL
- request_id — varchar(36) — Foreign key → silk_request.id
- identifier — int — NOT NULL
- analysis — longtext
taccounter
- accountID — int — Primary key — NOT NULL
- chngUserID — varchar(15)
- regDate — varchar(8)
- chngDate — varchar(8)
- mdfDttm — datetime(6) — NOT NULL
- comNm — varchar(30) — NOT NULL
- bizNo — varchar(10) — NOT NULL
- comAddr — varchar(100) — NOT NULL
- comAddr_detail — varchar(100)
- comHp — varchar(20) — NOT NULL
- licenseClass — varchar(1) — NOT NULL
- comID — int — Foreign key → tcompany.comID — NOT NULL
tauth
- authID — int — Primary key — NOT NULL
- email — varchar(50) — NOT NULL
- authNum — varchar(8) — NOT NULL
- bizNo — varchar(10)
- username — varchar(50)
- created — datetime(6) — NOT NULL
- expired — datetime(6) — NOT NULL
tb_cheminfo
- chemID — varchar(32) — Primary key — NOT NULL
- casNo — varchar(32)
- hashKey — varchar(100)
- 21년까지 — 등록하여야
- 21년까지 — 등록하여야
- 21년까지 — 등록하여야
- 21년까지 — 등록하여야
- 21년까지 — 등록하여야
- 고용노동부_CMR__고시일 — varchar(15)
- 고용노동부_CMR__관리자번호 — varchar(30)
- 고용노동부_CMR__규제번호 — varchar(30)
- 고용노동부_CMR__발암성 — varchar(300)
- 고용노동부_CMR__생식독성 — varchar(300)
- 고용노동부_CMR__생식세포변이원성 — varchar(300)
- 고용노동부_CMR__참조사항 — varchar(300)
- 고용노동부_CMR__함량기준설명 — varchar(300)
- 고용노동부_CMR__함량기준수치 — varchar(30)
- 금지물질_규정수량__고시일 — varchar(15)
- 금지물질_규정수량__관리자번호 — varchar(30)
- 금지물질_규정수량__규제번호 — varchar(30)
- 금지물질_규정수량__금지내용 — varchar(300)
- 금지물질_규정수량__상위_규정수량_ton_ — varchar(300)
- 금지물질_규정수량__하위_규정수량_ton_ — varchar(300)
- 금지물질_규정수량__함량기준설명 — varchar(300)
- 금지물질_규정수량__함량기준수치 — varchar(30)
- 기존화학물질__고시번호 — varchar(30)
- 기존화학물질__고시일 — varchar(15)
- 기존화학물질__관리자번호 — varchar(30)
- 기존화학물질__함량기준설명 — varchar(300)
- 기존화학물질__함량기준수치 — varchar(30)
- 등록대상기존화학물질__고시일 — varchar(15)
- 등록대상기존화학물질__관리자번호 — varchar(30)
- 등록대상기존화학물질__규제번호 — varchar(30)
- 등록대상기존화학물질__등록일자 — varchar(300)
- 등록대상기존화학물질__함량기준설명 — varchar(300)
- 등록대상기존화학물질__함량기준수치 — varchar(30)
- 사고대비물질_수량기준__고시일 — varchar(15)
- 사고대비물질_수량기준__관리자번호 — varchar(30)
- 사고대비물질_수량기준__규제번호 — varchar(30)
- 사고대비물질_수량기준__보호복 — varchar(300)
- 사고대비물질_수량기준__보호장갑 — varchar(300)
- 사고대비물질_수량기준__상위_규정수량_ton_ — varchar(300)
- 사고대비물질_수량기준__예외_사항 — varchar(300)
- 사고대비물질_수량기준__하위_규정수량_ton_ — varchar(300)
- 사고대비물질_수량기준__함량기준설명 — varchar(300)
- 사고대비물질_수량기준__함량기준수치 — varchar(30)
- 사고대비물질_수량기준__호흡보호구 — varchar(300)
- 산업안전보건법_금지물질__고시일 — varchar(15)
- 산업안전보건법_금지물질__관리자번호 — varchar(30)
- 산업안전보건법_금지물질__규제번호 — varchar(30)
- 산업안전보건법_금지물질__금지내용 — varchar(300)
- 산업안전보건법_금지물질__함량기준설명 — varchar(300)
- 산업안전보건법_금지물질__함량기준수치 — varchar(30)
- 산업안전보건법_허가물질__고시일 — varchar(15)
- 산업안전보건법_허가물질__관리자번호 — varchar(30)
- 산업안전보건법_허가물질__규제번호 — varchar(30)
- 산업안전보건법_허가물질__함량기준설명 — varchar(300)
- 산업안전보건법_허가물질__함량기준수치 — varchar(30)
- 유독물질_규정수량__고시일 — varchar(15)
- 유독물질_규정수량__관리자번호 — varchar(30)
- … +27
tcodelist
- codeId — int — Primary key — NOT NULL
- cdDmn — varchar(3) — NOT NULL
- cdDmnNm — varchar(100)
tcodes
- codesId — int — Primary key — NOT NULL
- cdCode — varchar(10)
- cdNm — varchar(100)
- cdOrd — int
- cdDmn — int — Foreign key → tcodelist.codeId — NOT NULL
tcompany
- comID — int — Primary key — NOT NULL
- expDate — varchar(8)
- comNm — varchar(20) — NOT NULL
- bizNo — varchar(10)
- representNm — varchar(10) — NOT NULL
- comAddr1 — varchar(100) — NOT NULL
- comAddr2 — varchar(100) — NOT NULL
- comHp — varchar(20)
- comEmail — varchar(50)
- managerID — varchar(50)
- managerNm — varchar(20)
- managerHp — varchar(20)
- managerEmail — varchar(50)
- taxComNm — varchar(20)
- taxBizNo — varchar(10)
- taxRepresentNm — varchar(20)
- taxComAddr1 — varchar(200)
- taxComAddr2 — varchar(200)
- taxManagerNm — varchar(20)
- taxManagerHp — varchar(20)
- taxManagerEmail — varchar(50)
- payMethod — varchar(20) — NOT NULL
- payType — varchar(20) — NOT NULL
- regDate — varchar(8)
- chngDate — varchar(8)
- mdfDttm — datetime(6) — NOT NULL
- noncas_cnt — int — NOT NULL
- secret_cnt — int — NOT NULL
- eventReceive — varchar(1)
- taxZipcode — varchar(10)
- zipcode — varchar(10)
- status — varchar(10)
- admissionFee — varchar(1) — NOT NULL
- apprStatus — varchar(10)
- customer_uid — varchar(20)
- checkYn — tinyint(1) — NOT NULL
- comType — varchar(10)
- comType_expDate — varchar(10)
- file_ID — varchar(20)
- membershipYn — varchar(1)
- comType_expDate_start — varchar(10)
- estimatedAmount — int — NOT NULL
- version — int — NOT NULL
tcompany_status
- statusID — int — Primary key — NOT NULL
- created — datetime(6) — NOT NULL
- status — varchar(10)
- comID — int — Foreign key → tcompany.comID — NOT NULL
tcrctmtrlrprt
- Crct_ID — int — Primary key — NOT NULL
- chngUserID — varchar(15)
- regDate — varchar(8)
- chngDate — varchar(8)
- mdfDttm — datetime(6) — NOT NULL
- crctMtrlQty — decimal(22,10) — NOT NULL
- itemNm — varchar(100)
- mtrlCtnt — decimal(22,10) — NOT NULL
- yearHandQty — decimal(22,10) — NOT NULL
- procAgency — varchar(20)
- receiptDate — varchar(8)
- receiptNo — varchar(20)
- issueDate — varchar(8)
- protectYn — varchar(1)
- file_ID — varchar(20)
- MtrlHC_ID — int — Foreign key → tmtrlinv_handclass.MtrlHC_ID — NOT NULL
- comID — int — Foreign key → tcompany.comID — NOT NULL
tcustomuser
- userID — int — Primary key — NOT NULL
- last_login — datetime(6)
- is_superuser — tinyint(1) — NOT NULL
- email — varchar(254) — NOT NULL
- is_staff — tinyint(1) — NOT NULL
- comID — int — Foreign key → tcompany.comID
- username — varchar(50) — NOT NULL
- password — varchar(100) — NOT NULL
- userNm — varchar(20) — NOT NULL
- department — varchar(15) — NOT NULL
- userHp — varchar(20)
- userEmail — varchar(50)
- authorization — varchar(10) — NOT NULL
- is_active — tinyint(1) — NOT NULL
- regDate — varchar(8)
- mdfDttm — datetime(6) — NOT NULL
tcustomuser_groups
- id — int — Primary key — NOT NULL
- tcustomuser_id — int — Foreign key → tcustomuser.userID — NOT NULL
- group_id — int — Foreign key → auth_group.id — NOT NULL
tcustomuser_user_permissions
- id — int — Primary key — NOT NULL
- tcustomuser_id — int — Foreign key → tcustomuser.userID — NOT NULL
- permission_id — int — Foreign key → auth_permission.id — NOT NULL
thazardlawrecord
- Record_ID — int — Primary key — NOT NULL
- chngUserID — varchar(15)
- regDate — varchar(8)
- chngDate — varchar(8)
- mdfDttm — datetime(6) — NOT NULL
- casNo — varchar(32) — NOT NULL
- yearHandQty — decimal(22,10) — NOT NULL
- file_ID — varchar(20)
- rprtDate — varchar(8)
- MtrlHC_ID — int — Foreign key → tmtrlinv_handclass.MtrlHC_ID — NOT NULL
- comID — int — Foreign key → tcompany.comID — NOT NULL
titeminv
- Item_ID — int — Primary key — NOT NULL
- chngUserID — varchar(15)
- regDate — varchar(8)
- chngDate — varchar(8)
- mdfDttm — datetime(6) — NOT NULL
- itemCd — varchar(20) — NOT NULL
- itemNm — varchar(100)
- handClass — varchar(8)
- itemPrpsYn — varchar(1)
- regYn — varchar(1)
- singleMtrlYn — varchar(1)
- regExstMtrlYn — varchar(1)
- exstMtrlYn — varchar(1)
- newMtrlYn — varchar(1)
- toxicMtrlYn — varchar(1)
- accdMtrlYn — varchar(1)
- prohMtrlYn — varchar(1)
- rstrMtrlYn — varchar(1)
- crctMtrlYn — varchar(1)
- prmtMtrlYn — varchar(1)
- MtrlWt — decimal(22,10) — NOT NULL
- regulDoneYn — varchar(1)
- hsCd — varchar(10)
- handUnit — varchar(5)
- handQty — decimal(22,10) — NOT NULL
- planHandQty — decimal(22,10) — NOT NULL
- reexamineYn — varchar(1)
- examineDate — varchar(8)
- approvalDate — varchar(8)
- madeDate — varchar(8)
- receiptNo — varchar(20)
- amount — decimal(22,10) — NOT NULL
- file_ID — varchar(20)
- bigo — varchar(100)
- useYn — varchar(1)
- Report_Info_ID — int — Foreign key → titeminv_report_info.Report_Info_ID
- SEQ — varchar(30) — Foreign key → tseq.SEQ — NOT NULL
- comID — int — Foreign key → tcompany.comID — NOT NULL
titeminv_report_info
- Report_Info_ID — int — Primary key — NOT NULL
- chngUserID — varchar(15)
- regDate — varchar(8)
- chngDate — varchar(8)
- mdfDttm — datetime(6) — NOT NULL
- toxicMtrl_approvalDate — varchar(8)
- toxicMtrl_madeDate — varchar(8)
- toxicMtrl_receiptNo — varchar(20)
- toxicMtrl_amount — decimal(22,10) — NOT NULL
- prohMtrl_approvalDate — varchar(8)
- prohMtrl_madeDate — varchar(8)
- prohMtrl_receiptNo — varchar(20)
- prohMtrl_amount — decimal(22,10) — NOT NULL
- rstrMtrl_approvalDate — varchar(8)
- rstrMtrl_madeDate — varchar(8)
- rstrMtrl_receiptNo — varchar(20)
- rstrMtrl_amount — decimal(22,10) — NOT NULL
- comID — int — Foreign key → tcompany.comID — NOT NULL
- file_ID — varchar(20)
titeminv_sku
- SKU_ID — int — Primary key — NOT NULL
- chngUserID — varchar(15)
- regDate — varchar(8)
- chngDate — varchar(8)
- mdfDttm — datetime(6) — NOT NULL
- SKUNm — varchar(100)
- distributor — varchar(100)
- weight_field — decimal(22,10) — NOT NULL
- weight_unit — varchar(5)
- conversion_factor — decimal(10,5) — NOT NULL
- weight_kg — decimal(22,10) — NOT NULL
- useYn — varchar(1)
- comID — int — Foreign key → tcompany.comID — NOT NULL
- SEQ — varchar(30) — Foreign key → tseq.SEQ — NOT NULL
titemmtrlbom
- Bom_ID — int — Primary key — NOT NULL
- chngUserID — varchar(15)
- regDate — varchar(8)
- chngDate — varchar(8)
- mdfDttm — datetime(6) — NOT NULL
- casNo — varchar(32) — NOT NULL
- reviewYn — varchar(1) — NOT NULL
- mtrlNmEng — varchar(500) — NOT NULL
- mtrlMinCtnt — decimal(22,10) — NOT NULL
- mtrlMaxCtnt — decimal(22,10) — NOT NULL
- mtrlClass — varchar(10)
- toxicMtrlYn — varchar(1)
- accdMtrlYn — varchar(1)
- prohMtrlYn — varchar(1)
- rstrMtrlYn — varchar(1)
- crctMtrlYn — varchar(1)
- prmtMtrlYn — varchar(1)
- Mtrl_ID — int — Foreign key → tmtrlinv.Mtrl_ID
- SEQ — varchar(30) — Foreign key → tseq.SEQ — NOT NULL
- comID — int — Foreign key → tcompany.comID — NOT NULL
titemrecord
- Record_ID — int — Primary key — NOT NULL
- chngUserID — varchar(15)
- regDate — varchar(8)
- chngDate — varchar(8)
- mdfDttm — datetime(6) — NOT NULL
- handDate — varchar(8) — NOT NULL
- incomOutgoYn — varchar(1) — NOT NULL
- handClass — varchar(5) — NOT NULL
- handQty — decimal(22,10) — NOT NULL
- unit — varchar(5)
- cnt — int — NOT NULL
- accounterUsePrps — varchar(3)
- convHandItemQty — decimal(22,10) — NOT NULL
- rprtNo — varchar(20)
- hsCd — varchar(15)
- bigo — varchar(50)
- manageNo — varchar(20)
- Item_ID — int — Foreign key → titeminv.Item_ID — NOT NULL
- accountID — int — Foreign key → taccounter.accountID
- comID — int — Foreign key → tcompany.comID — NOT NULL
- grossWt — decimal(22,10) — NOT NULL
titemyearqty
- yearQtyID — int — Primary key — NOT NULL
- year — varchar(4) — NOT NULL
- handClass — varchar(10) — NOT NULL
- handQty — decimal(22,10) — NOT NULL
- planHandQty — decimal(22,10) — NOT NULL
- Item_ID — int — Foreign key → titeminv.Item_ID — NOT NULL
- comID — int — Foreign key → tcompany.comID — NOT NULL
tkit
- kit_ID — int — Primary key — NOT NULL
- item_info — json — NOT NULL
tmessage
- id — int — Primary key — NOT NULL
- userID — int
- username — varchar(255) — NOT NULL
- content — longtext — NOT NULL
- date_added — datetime(6) — NOT NULL
- room — varchar(255) — NOT NULL
tmtrlinv
- Mtrl_ID — int — Primary key — NOT NULL
- chngUserID — varchar(15)
- regDate — varchar(8)
- chngDate — varchar(8)
- mdfDttm — datetime(6) — NOT NULL
- casNo — varchar(32) — NOT NULL
- casNoYn — varchar(1)
- mtrlNmEng — varchar(500)
- mtrlNmKor — varchar(500)
- singleItemYn — varchar(1)
- atomForm — varchar(100)
- moleForm — varchar(100)
- mtrlNmClass — varchar(5)
- handClass — varchar(5)
- regReviewYn — varchar(1) — NOT NULL
- exstMtrlYn — varchar(1)
- prevYn — varchar(1)
- prevRprtYn — varchar(1)
- prevRprtFile_ID — varchar(20)
- regExstMtrlYn — varchar(1)
- regExstMtrlRprtYn — varchar(1)
- regExstMtrlRprtFile_ID — varchar(20)
- regExmptYn — varchar(1)
- regExmptRprtYn — varchar(1)
- regExmptRprtFile_ID — varchar(20)
- newMtrlYn — varchar(1)
- newMtrlRprtYn — varchar(1)
- newMtrlRprtFile_ID — varchar(20)
- crctMtrlYn — varchar(1)
- crctMtrlImpleYn — varchar(1)
- crctMtrlRprtYn — varchar(1)
- crctMtrlRprtFile_ID — varchar(20)
- hazardLawYn — varchar(1)
- hazardLawRprtYn — varchar(1)
- hazardLawRprtFile_ID — varchar(20)
- toxicMtrlYn — varchar(1)
- toxicMtrlRglrNo — varchar(80)
- toxicMtrlCtnt — decimal(22,10)
- accdMtrlYn — varchar(1)
- accdMtrlRglrNo — varchar(80)
- accdMtrlCtnt — decimal(22,10)
- prohMtrlYn — varchar(1)
- prohMtrlRglrNo — varchar(80)
- prohMtrlCtnt — decimal(22,10)
- rstrMtrlYn — varchar(1)
- rstrMtrlRglrNo — varchar(80)
- rstrMtrlCtnt — decimal(22,10)
- prmtMtrlYn — varchar(1)
- prmtMtrlRglrNo — varchar(80)
- prmtMtrlCtnt — decimal(22,10)
- impleyn — varchar(2)
- reexamineYn — varchar(1)
- examineDate — varchar(8)
- bigo — varchar(50)
- importQty — decimal(22,10) — NOT NULL
- produceQty — decimal(22,10) — NOT NULL
- purchaseQty — decimal(22,10) — NOT NULL
- exportQty — decimal(22,10) — NOT NULL
- useQty — decimal(22,10) — NOT NULL
- sellQty — decimal(22,10) — NOT NULL
- … +5
tmtrlinv_handclass
- MtrlHC_ID — int — Primary key — NOT NULL
- chngUserID — varchar(15)
- regDate — varchar(8)
- chngDate — varchar(8)
- mdfDttm — datetime(6) — NOT NULL
- handClass — varchar(10) — NOT NULL
- status — varchar(10)
- gracePeriod — varchar(8)
- prevRprtQty — decimal(22,10)
- prevRprtCd — varchar(20)
- prevRprtDate — varchar(8)
- regExstMtrlRprtQty — decimal(22,10)
- regExstMtrlRprtCd — varchar(20)
- regExstMtrlRprtDate — varchar(8)
- regExmptRprtQty — decimal(22,10)
- regExmptRprtCd — varchar(20)
- regExmptRprtDate — varchar(8)
- newMtrlRprtCd — varchar(20)
- newMtrlRprtDate — varchar(8)
- crctMtrlRprtCd — varchar(20)
- crctMtrlRprtDate — varchar(8)
- hazardLawRprtQty — decimal(22,10)
- hazardLawRprtCd — varchar(20)
- hazardLawRprtDate — varchar(8)
- impleyn — varchar(2)
- impendYn — varchar(2)
- Mtrl_ID — int — Foreign key → tmtrlinv.Mtrl_ID — NOT NULL
- comID — int — Foreign key → tcompany.comID — NOT NULL
tmtrlqty
- MtrlQty_ID — int — Primary key — NOT NULL
- chngUserID — varchar(15)
- regDate — varchar(8)
- chngDate — varchar(8)
- mdfDttm — datetime(6) — NOT NULL
- accountID — varchar(10)
- casNo — varchar(32)
- mtrlNmEng — varchar(500)
- year — varchar(4) — NOT NULL
- handClass — varchar(10) — NOT NULL
- itemQty — decimal(22,10) — NOT NULL
- mtrlQty — decimal(22,10) — NOT NULL
- rate — decimal(22,10) — NOT NULL
- Item_ID — int — Foreign key → titeminv.Item_ID — NOT NULL
- Mtrl_ID — int — Foreign key → tmtrlinv.Mtrl_ID — NOT NULL
- Record_ID — int — Foreign key → titemrecord.Record_ID — NOT NULL
- comID — int — Foreign key → tcompany.comID — NOT NULL
tnewmtrlrprt
- New_ID — int — Primary key — NOT NULL
- chngUserID — varchar(15)
- regDate — varchar(8)
- chngDate — varchar(8)
- mdfDttm — datetime(6) — NOT NULL
- regForm — varchar(20)
- prpsClass — varchar(20)
- accounterUsePrps — varchar(50)
- itemPrps — varchar(50)
- receiptDate — varchar(8)
- receiptNo — varchar(20)
- issueDate — varchar(8)
- protectYn — varchar(1)
- file_ID — varchar(20)
- MtrlHC_ID — int — Foreign key → tmtrlinv_handclass.MtrlHC_ID — NOT NULL
- comID — int — Foreign key → tcompany.comID — NOT NULL
tnotice
- notiID — int — Primary key — NOT NULL
- chngUserID — varchar(15)
- regDate — varchar(10)
- mdfDttm — datetime(6) — NOT NULL
- title — varchar(50) — NOT NULL
- body — longtext — NOT NULL
- secretYn — tinyint(1) — NOT NULL
- file_ID — varchar(20)
tnotification
- notiID — int — Primary key — NOT NULL
- code — int
- title — varchar(50) — NOT NULL
- key — varchar(50) — NOT NULL
- pagename — varchar(50) — NOT NULL
- url — varchar(100) — NOT NULL
- type — varchar(10) — NOT NULL
tnotificationcount
- countID — int — Primary key — NOT NULL
- code — int
- cnt — int — NOT NULL
- mdfDttm — datetime(6) — NOT NULL
- comID — int — Foreign key → tcompany.comID — NOT NULL
tpartnership_info
- infoID — int — Primary key — NOT NULL
- chngUserID — varchar(15)
- regDate — varchar(10)
- mdfDttm — datetime(6) — NOT NULL
- contactComName — varchar(30) — NOT NULL
- contactName — varchar(10) — NOT NULL
- contactEmail — varchar(50) — NOT NULL
- contactPhone — varchar(15) — NOT NULL
- contactSubject — varchar(50) — NOT NULL
- contactMessage — varchar(300) — NOT NULL
tpayment
- ID — int — Primary key — NOT NULL
- amount — varchar(10) — NOT NULL
- comID — int — Foreign key → tcompany.comID — NOT NULL
- payMethod — varchar(10) — NOT NULL
- expDate — varchar(10)
- payDate — varchar(10)
- regDttm — datetime(6) — NOT NULL
- bigo — varchar(30)
- imp_uid — varchar(30)
- paymentType — varchar(1) — NOT NULL
- startDate — varchar(10)
tprevmtrlrprt
- prev_ID — int — Primary key — NOT NULL
- chngUserID — varchar(15)
- regDate — varchar(8)
- chngDate — varchar(8)
- mdfDttm — datetime(6) — NOT NULL
- yearHandQty — decimal(22,10) — NOT NULL
- receiptDate — varchar(8)
- receiptNo — varchar(20)
- file_ID — varchar(20)
- MtrlHC_ID — int — Foreign key → tmtrlinv_handclass.MtrlHC_ID — NOT NULL
- comID — int — Foreign key → tcompany.comID — NOT NULL
tprmrecord
- Record_ID — int — Primary key — NOT NULL
- chngUserID — varchar(15)
- regDate — varchar(8)
- chngDate — varchar(8)
- mdfDttm — datetime(6) — NOT NULL
- prmQty — decimal(22,10) — NOT NULL
- businessClass — varchar(10)
- file_ID — varchar(20)
- prmStorageQty — decimal(22,10) — NOT NULL
- receiptNo — varchar(20)
- bigo — varchar(50)
- comID — int — Foreign key → tcompany.comID — NOT NULL
tprmrecord_inv
- prm_Inv_ID — int — Primary key — NOT NULL
- chngUserID — varchar(15)
- regDate — varchar(8)
- chngDate — varchar(8)
- mdfDttm — datetime(6) — NOT NULL
- Item_ID — int — Foreign key → titeminv.Item_ID — NOT NULL
- comID — int — Foreign key → tcompany.comID — NOT NULL
- prm_Mtrl_ID — int — Foreign key → tprmrecord_mtrl.prm_Mtrl_ID — NOT NULL
tprmrecord_mtrl
- prm_Mtrl_ID — int — Primary key — NOT NULL
- chngUserID — varchar(15)
- regDate — varchar(8)
- chngDate — varchar(8)
- mdfDttm — datetime(6) — NOT NULL
- prmQty_mtrl — decimal(22,10) — NOT NULL
- Mtrl_ID — int — Foreign key → tmtrlinv.Mtrl_ID — NOT NULL
- Record_ID — int — Foreign key → tprmrecord.Record_ID — NOT NULL
- comID — int — Foreign key → tcompany.comID — NOT NULL
trecordinfo
- RecordInfo_ID — int — Primary key — NOT NULL
- approvalDate — varchar(8)
- madeDate — varchar(8)
- receiptNo — varchar(20)
- amount — decimal(22,10) — NOT NULL
- file_ID — varchar(20)
- bigo — varchar(100)
- Record_ID — int — Foreign key → titemrecord.Record_ID — NOT NULL
tregexmptmtrlrprt
- RegExmpt_ID — int — Primary key — NOT NULL
- chngUserID — varchar(15)
- regDate — varchar(8)
- chngDate — varchar(8)
- mdfDttm — datetime(6) — NOT NULL
- yearHandQty — decimal(22,10) — NOT NULL
- exemClass — varchar(20)
- prpsClass — varchar(20)
- itemPrps — varchar(50)
- exmptCause — varchar(200)
- receiptDate — varchar(8)
- receiptNo — varchar(20)
- issueDate — varchar(8)
- expiryDate — varchar(8)
- protectYn — varchar(1)
- file_ID — varchar(20)
- MtrlHC_ID — int — Foreign key → tmtrlinv_handclass.MtrlHC_ID — NOT NULL
- comID — int — Foreign key → tcompany.comID — NOT NULL
tregexstmtrlrprt
- RegExst_ID — int — Primary key — NOT NULL
- chngUserID — varchar(15)
- regDate — varchar(8)
- chngDate — varchar(8)
- mdfDttm — datetime(6) — NOT NULL
- yearHandQty — decimal(22,10) — NOT NULL
- regForm — varchar(20)
- prpsClass — varchar(20)
- accounterUsePrps — varchar(50)
- itemPrps — varchar(50)
- receiptDate — varchar(8)
- receiptNo — varchar(20)
- issueDate — varchar(8)
- representNm — varchar(20)
- consultCom — varchar(20)
- protectYn — varchar(1)
- file_ID — varchar(20)
- MtrlHC_ID — int — Foreign key → tmtrlinv_handclass.MtrlHC_ID — NOT NULL
- comID — int — Foreign key → tcompany.comID — NOT NULL
tsearchcount
- countID — int — Primary key — NOT NULL
- casNo — varchar(20)
- chemID — varchar(20)
- userNm — varchar(10)
- mdfDttm — datetime(6) — NOT NULL
- comID — int — Foreign key → tcompany.comID — NOT NULL
tseq
- SEQ — varchar(30) — Primary key — NOT NULL
- SEQNO — int — NOT NULL
- target — varchar(20) — NOT NULL
- targetTable — varchar(15)
- created — datetime(6) — NOT NULL
- bigo — varchar(30) — NOT NULL
- comID — int — Foreign key → tcompany.comID — NOT NULL
tstatuscheck
- status — varchar(32) — Primary key — NOT NULL
tupdatemtrl
- casNo — varchar(32) — Primary key — NOT NULL
- updateDate — varchar(8) — NOT NULL
tupdatemtrl_copy
- updateID — int — Primary key — NOT NULL
- casNo — varchar(32) — NOT NULL
- updateDate — varchar(8) — NOT NULL
- regNm — varchar(20)
usersession
- sid — int — Primary key — NOT NULL
- username — varchar(50) — NOT NULL
- session_key — varchar(40) — NOT NULL