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