CIS
Tables (63)
activities (Untitled48)
- seq (Key) — Primary key — NOT NULL
- contract (Key2) — Foreign key → contract.seq — NOT NULL
activities (Untitled53)
- seq (Key) — Primary key — NOT NULL
- business_unit_seq (Key2) — Foreign key → business_units.seq — NOT NULL
- manager_seq (Key3) — Foreign key → member.seq — NOT NULL
- complete_document_seq (Key5) — Foreign key → document.seq — NOT NULL
activities (Untitled10)
- seq (Key) — Primary key — NOT NULL
- contract (Key2) — Foreign key → contract.seq — NOT NULL
- deal (Key3) — Foreign key → deal.seq — NOT NULL
- site (Key4) — Foreign key → site.seq — NOT NULL
- product_type (Key5) — Foreign key → config_product.seq — NOT NULL
- engineer (Key6) — Foreign key → member.seq — NOT NULL
- engineer2 (Key7) — Foreign key → member.seq — NOT NULL
- owner (Key8) — Foreign key → member.seq — NOT NULL
- activities_type (Key9) — Foreign key → config_activities.seq — NOT NULL
activities_file (Untitled66)
- activities_seq (Key) — Foreign key → activities.seq — NOT NULL
- activities_item_seq (Key4) — Foreign key → activities_item.seq — NOT NULL
activities_file (Untitled33)
- activities (Key) — Foreign key → activities.seq — NOT NULL
- owner (Key2) — Foreign key → member.seq — NOT NULL
activities_file (Untitled65)
- activities_seq (Key) — Foreign key → activities.seq — NOT NULL
- owner_seq (Key2) — Foreign key → member.seq — NOT NULL
activities_item (Untitled54)
- seq (Key4) — Primary key — NOT NULL
- activities_seq (Key) — Foreign key → activities.seq — NOT NULL
- manager_seq (Key2) — 여러개 — Foreign key → member.seq — NOT NULL
- product_code (Key3) — 하나만 — Foreign key → config_product.seq — NOT NULL
- content(item1) (Field6)
- type (Field)
- startDueDate (Field2)
- endDueDate (Field3)
- startDate (Field5)
- endDate (Field11)
- status (Field4)
- owner_seq (Field10)
- CreateAt (Field7)
- UpdateAt (Field8)
- DEL_FLAG (Field9)
activities_item (Untitled50)
- activities (Key) — Foreign key → activities.seq — NOT NULL
- owner (Key2) — Foreign key → member.seq — NOT NULL
activities_item (Untitled11)
- acitivities (Key) — Foreign key → activities.seq — NOT NULL
- owner (Key2) — Foreign key → member.seq — NOT NULL
activities_ref (Untitled63)
- activities_seq (Key) — Foreign key → activities.seq — NOT NULL
- member_seq (Key2) — Foreign key → member.seq — NOT NULL
activities_ref (Untitled7)
- member (Key) — Foreign key → member.seq — NOT NULL
- activities (Key2) — Foreign key → activities.seq — NOT NULL
annual (Untitled19)
- member (Key) — Foreign key → member.seq — NOT NULL
annual_plan (Untitled20)
- document (Key2) — Foreign key → document.seq — NOT NULL
apply_new_org (Untitled22)
approval_line (Untitled15)
- owner (Key) — Foreign key → member.seq — NOT NULL
bill (Untitled42)
- contract (Key2) — Foreign key → contract.seq — NOT NULL
business_units (Untitled52)
- seq (Key) — Primary key — NOT NULL
- type (Field) — 고객지원/정기점검/내부업무
- name (Field2) — char
- manager (Key2) — member_seq — Foreign key → member.seq — NOT NULL
- start_time (Field3) — timestamp
- end_time (Field4) — timestamp
- description (Field7) — text
- status (Field6) — 0,1
calendar (Untitled9)
code2 (Untitled29)
- seq (Key) — Primary key — NOT NULL
- code (Key2) — Primary key — NOT NULL
- pcode (Key3) — Foreign key → code2.seq — NOT NULL
config_activities (Untitled40)
- seq (Key) — Primary key — NOT NULL
- pseq (Key2) — Foreign key → config_activities.seq — NOT NULL
- dept (Key3) — Foreign key → organization.seq — NOT NULL
- owner (Key4) — Foreign key → member.seq — NOT NULL
- modifier (Key5) — Foreign key → member.seq — NOT NULL
config_job_position (Untitled30)
- seq (Key) — Primary key — NOT NULL
config_menu (Untitled32)
- seq (Key) — Primary key — NOT NULL
- pseq (Key2) — Foreign key → config_menu.seq — NOT NULL
config_menu_group (Untitled5)
- seq (Key) — Primary key — NOT NULL
config_product (Untitled34)
- seq (Key) — Primary key — NOT NULL
- pseq (Key2) — Foreign key → config_product.seq — NOT NULL
- vendor (Key3) — Foreign key → config_vendor.seq — NOT NULL
- modifier (Key4) — Foreign key → member.seq — NOT NULL
config_product (Untitled55)
- seq (Key) — Primary key — NOT NULL
config_vendor (Untitled6)
- seq (Key) — Primary key — NOT NULL
contract (Untitled23)
- seq (Key) — Primary key — NOT NULL
- sales_manager (Key2) — Foreign key → member.seq — NOT NULL
- sales_manager2 (Key3) — Foreign key → member.seq — NOT NULL
- engineer (Key4) — Foreign key → member.seq — NOT NULL
- engineer2 (Key5) — Foreign key → member.seq — NOT NULL
- pic (Key22) — Foreign key → customer.seq — NOT NULL
- modifier (Key6) — Foreign key → member.seq — NOT NULL
- owner (Key7) — Foreign key → member.seq — NOT NULL
contract (Untitled49)
- seq (Key) — Primary key — NOT NULL
contract (Untitled51)
- seq (Key2) — Primary key — NOT NULL
- business_unit_seq (Key) — Foreign key → business_units.seq — NOT NULL
contract_file (Untitled24)
contract_history (Untitled25)
customer (Untitled28)
- seq (Key2) — Primary key — NOT NULL
- site (Key) — Foreign key → site.seq — NOT NULL
deal (Untitled36)
- seq (Key) — Primary key — NOT NULL
- product (Key2) — Foreign key → config_product.seq — NOT NULL
- site (Key3) — Foreign key → site.seq — NOT NULL
- e_site (Key4) — Foreign key → site.seq — NOT NULL
- owner (Key5) — Foreign key → member.seq — NOT NULL
deal_bill (Untitled26)
- deal (Key) — Foreign key → deal.seq — NOT NULL
document (Untitled62)
- seq (Key) — Primary key — NOT NULL
document (Untitled43)
- seq (Key2) — Primary key — NOT NULL
- ref (Key) — Foreign key → contract.seq — NOT NULL
- approver (Key3) — Foreign key → member.seq — NOT NULL
- owner (Key4) — Foreign key → member.seq — NOT NULL
document_msg (Untitled21)
- document (Key2) — Foreign key → document.seq — NOT NULL
- member (Key) — Foreign key → member.seq — NOT NULL
document_ref (Untitled45)
- document (Key2) — Foreign key → document.seq — NOT NULL
- member (Key) — Foreign key → member.seq — NOT NULL
file (Untitled17)
- ID (Key) — Primary key — NOT NULL
- folder (Key2) — Foreign key → file_folder.seq — NOT NULL
- owner (Key3) — Foreign key → member.seq — NOT NULL
file_folder (Untitled31)
- seq (Key) — Primary key — NOT NULL
- pseq (Key2) — Foreign key → file_folder.seq — NOT NULL
- owner (Key3) — Foreign key → member.seq — NOT NULL
file_history (Untitled16)
- member (Key2) — Foreign key → member.seq — NOT NULL
- FILE_ID (Key) — Foreign key → file.ID — NOT NULL
flag (Untitled8)
log_add_remove (Untitled64)
- parent_entity (Field3) — buisiness,_units activities
- child_entity (Field4) — manager, products, contract,
- parent_entity_seq (Field5)
- child_entity_seq (Field6)
- status (Field2)
- edit_date (Field)
mail (Untitled18)
mapper_table (Untitled4)
mapping_assigned_entities (Untitled56)
- parent_entity_code (Field) — contract, business_units, activities, activity_item
- parent_entity_seq (Field2)
- assigned_entity_code (Field3) — product, member
- assigned_entity_seq (Field4)
member (Untitled12)
- seq (Key) — Primary key — NOT NULL
- job_position (Key2) — Foreign key → config_job_position.seq — NOT NULL
- menu_group (Key3) — Foreign key → config_menu_group.seq — NOT NULL
member (Untitled59)
- seq (Key) — Primary key — NOT NULL
member (Untitled58)
- seq (Key) — Primary key — NOT NULL
mig_site_ref (Untitled13)
notification (Untitled35)
organization (Untitled37)
- seq (Key) — Primary key — NOT NULL
- pseq (Key2) — Foreign key → organization.seq — NOT NULL
- member (Key3) — Foreign key → member.seq — NOT NULL
purchase (Untitled46)
- seq (Key5) — Primary key — NOT NULL
- contract (Key) — Foreign key → contract.seq — NOT NULL
- site (Key2) — Foreign key → site.seq — NOT NULL
- pic (Key22) — Foreign key → customer.seq — NOT NULL
- sales_manager (Key3) — Foreign key → member.seq — NOT NULL
- modifier (Key4) — Foreign key → member.seq — NOT NULL
purchase_item (Untitled47)
- purchase (Key5) — Foreign key → purchase.seq — NOT NULL
- contract (Key) — Foreign key → contract.seq — NOT NULL
- product (Key2) — Foreign key → config_product.seq — NOT NULL
sales (Untitled)
- seq (Key) — Primary key — NOT NULL
- contract (Key2) — Foreign key → contract.seq — NOT NULL
- site (Key3) — Foreign key → site.seq — NOT NULL
- e_site (Key4) — Foreign key → site.seq — NOT NULL
- pic (Key22) — Foreign key → customer.seq — NOT NULL
- e_pic (Key23) — Foreign key → customer.seq — NOT NULL
- sales_manager (Key5) — Foreign key → member.seq — NOT NULL
- modifier (Key6) — Foreign key → member.seq — NOT NULL
sales_history (Untitled44)
- sales_seq (Key) — Foreign key → sales.seq — NOT NULL
- contract (Key2) — Foreign key → contract.seq — NOT NULL
- document (Key22) — Foreign key → document.seq — NOT NULL
- site (Key3) — Foreign key → site.seq — NOT NULL
- e_site (Key4) — Foreign key → site.seq — NOT NULL
- pic (Key23) — Foreign key → customer.seq — NOT NULL
- e_pic (Key24) — Foreign key → customer.seq — NOT NULL
- sales_manager (Key5) — Foreign key → member.seq — NOT NULL
- modifier (Key6) — Foreign key → member.seq — NOT NULL
sales_item (Untitled2)
- sales (Key) — Foreign key → sales.seq — NOT NULL
- product (Key2) — Foreign key → config_product.seq — NOT NULL
- contract (Key3) — Foreign key → contract.seq — NOT NULL
sales_quater (Untitled38)
- dept (Key) — Foreign key → organization.seq — NOT NULL
- member (Key2) — Foreign key → member.seq — NOT NULL
sales_quater (Untitled39)
- dept (Key) — Foreign key → organization.seq — NOT NULL
- member (Key2) — Foreign key → member.seq — NOT NULL
schedule (Untitled41)
- owner (Key) — Foreign key → member.seq — NOT NULL
- site (Key2) — Foreign key → site.seq — NOT NULL
- pic (Key22) — Foreign key → customer.seq — NOT NULL
schedule_ref ? (Untitled14)
shared_member (Untitled3)
site (Untitled27)
- seq (Key) — Primary key — NOT NULL
- industry (Key22) — Foreign key → code2.code — NOT NULL