test
Tables (18)
attachfile
- idnumber — varchar(12) — Primary key — NOT NULL
- ref_idnumber — varchar(12) — NOT NULL
- filetype — varchar(100)
- file_name — varchar(300) — NOT NULL
- location — varchar(300) — NOT NULL
- size — int4
- c_date — timestamptz
board
- idnumber — varchar(255) — Primary key — NOT NULL
- dtype — varchar(31) — NOT NULL
- c_date — timestamp
- m_date — timestamp
- c_user — varchar(255)
- m_user — varchar(255)
- description — text
- read_count — int4
- title — varchar(255)
- created_by — varchar(255)
- modified_by — varchar(255)
customer
- idnumber — varchar(12) — Primary key — NOT NULL
- name — varchar(100) — NOT NULL
- name_en — varchar(100)
- ptc_no — varchar(100)
- address — varchar(300)
- description — varchar(600)
- c_user — varchar(100) — NOT NULL
- m_user — varchar(100) — NOT NULL
- c_date — timestamptz
- m_date — timestamptz
- oid — int4
department
- idnumber — varchar(12) — Primary key — NOT NULL
- code — varchar(100) — NOT NULL
- pcode — varchar(100)
- sort — int4 — NOT NULL
- c_date — timestamptz
- m_date — timestamptz
- parent — varchar(255)
download_history
- idnumber — varchar(12) — Primary key — NOT NULL
- module — varchar(100)
- ref_idnumber — varchar(12) — NOT NULL
- filename — varchar(300) — NOT NULL
- count — int4 — NOT NULL
- ip — varchar(15) — NOT NULL
- c_user — varchar(100) — NOT NULL
- c_date — timestamptz
- created_by — varchar(255)
- attach_file — varchar(255)
favorite
- idnumber — varchar(12) — Primary key — NOT NULL
- name — varchar(100) — NOT NULL
- url — varchar(255) — NOT NULL
- c_user — varchar(100) — NOT NULL
- c_date — timestamptz
gwuser
- idnumber — varchar(12) — Primary key — NOT NULL
- id — varchar(50) — NOT NULL
- name — varchar(100) — NOT NULL
- email — varchar(100)
- password — varchar(100) — NOT NULL
- dept_code — varchar(100)
- grade_code — varchar(100)
- joindate — varchar(100)
- cellphonenumber — varchar(100)
- phonenumber — varchar(100)
- address — varchar(200)
- enabled — bool — NOT NULL
- c_date — timestamptz
- m_date — timestamptz
- age — int4
- userrole_ref_idnumber — varchar(255)
login_history
- idnumber — varchar(12) — Primary key — NOT NULL
- ip — varchar(15) — NOT NULL
- browser — varchar(100) — NOT NULL
- c_user — varchar(100) — NOT NULL
- c_date — timestamptz
- created_by — varchar(255)
notice
- idnumber — varchar(12) — Primary key — NOT NULL
- title — varchar(600) — NOT NULL
- contents — varchar(4000)
- creator — varchar(100) — NOT NULL
- c_date — timestamptz
- m_date — timestamptz
- read_count — int4
- notify_type — varchar(150)
numbercode
- idnumber — varchar(12) — Primary key — NOT NULL
- codetype — varchar(100) — NOT NULL
- code — varchar(100) — NOT NULL
- name — varchar(100) — NOT NULL
- pcode — varchar(100)
- sort — int4 — NOT NULL
- description — varchar(600)
- parent — bool — NOT NULL
- enabled — bool — NOT NULL
- c_date — timestamptz
- m_date — timestamptz
- engname — varchar(100)
- ref_idnumber — varchar(255)
- parent_number_code — varchar(255)
numbercodetype
- idnumber — varchar(12) — Primary key — NOT NULL
- code — varchar(100) — NOT NULL
- name — varchar(100) — NOT NULL
- sort — int4 — NOT NULL
- description — varchar(600)
- enabled — bool — NOT NULL
- c_date — timestamptz
- m_date — timestamptz
purchase_order
- idnumber — varchar(12) — Primary key — NOT NULL
- ref_idnumber — varchar(12) — NOT NULL
- confirm_date — varchar(10) — NOT NULL
- description — varchar(600)
- product_code — varchar(600)
- quantity — int4 — NOT NULL
- product_type — varchar(100)
- maintenance_expiration_date — varchar(10) — NOT NULL
- maintenance_type — varchar(100)
- c_user — varchar(100) — NOT NULL
- m_user — varchar(100) — NOT NULL
- c_date — timestamptz
- m_date — timestamptz
- created_by — varchar(255)
- modified_by — varchar(255)
- maintenance_type_code — varchar(255)
- product_type_code — varchar(255)
resources
- idnumber — varchar(255) — Primary key — NOT NULL
- c_date — timestamp
- m_date — timestamp
- http_method — varchar(255)
- order_num — int4
- resource_name — varchar(255)
- resource_type — varchar(255)
- ref_idnumber — varchar(255)
roleresources
- idnumber — varchar(255) — Primary key — NOT NULL
- c_date — timestamp
- m_date — timestamp
roles
- idnumber — varchar(255) — Primary key — NOT NULL
- c_date — timestamp
- m_date — timestamp
- role_desc — varchar(255)
- role_name — varchar(255)
- roleresource_ref_idnumber — varchar(255)
- userrole_ref_idnumber — varchar(255)
sales_item_doc
- idnumber — varchar(12) — Primary key — NOT NULL
- ref_idnumber — varchar(12) — NOT NULL
- sales_doc_type — varchar(100) — NOT NULL
- c_user — varchar(100) — NOT NULL
- m_user — varchar(100) — NOT NULL
- c_date — timestamptz
- m_date — timestamptz
- oid — int4
- salesdoc_coderef_idnumber — varchar(255)
sales_master_doc
- idnumber — varchar(12) — Primary key — NOT NULL
- Key — Primary key — NOT NULL
- ref_idnumber — varchar(12) — NOT NULL
- sales_type — varchar(100) — NOT NULL
- sales_user — varchar(100) — NOT NULL
- order_date — varchar(10) — NOT NULL
- description — varchar(600)
- c_user — varchar(100) — NOT NULL
- m_user — varchar(100) — NOT NULL
- c_date — timestamptz
- m_date — timestamptz
- oid — int4
- created_by — varchar(255)
- modified_by — varchar(255)
- sales_type_code — varchar(255)
- Field
- Field2
- Field3
- Field4
usersroles
- idnumber — varchar(255) — Primary key — NOT NULL
- c_date — timestamp
- m_date — timestamp