DACS
Tables (7)
TBDACS_BAT_SCH
- idx — NUMBER — Primary key — NOT NULL
- check_rule_idx (TBDACS_STD PK) — NUMBER — Foreign key → TBDACS_STD.idx — NOT NULL
- cycle — VARCHAR2(20) — NOT NULL
- start_time — VARCHAR2(5) — NOT NULL
- start_date — DATE — NOT NULL
- end_date — DATE — NOT NULL
- server — VARCHAR2(20) — NOT NULL
- available — VARCHAR2(5) — NOT NULL
- ship_no — VARCHAR2(10) — NOT NULL
- block — VARCHAR2(20) — NOT NULL
- function (function_idx) — VARCHAR2(50) — NOT NULL
- start_dp_day — VARCHAR2(10) — NOT NULL
- end_dp_day — VARCHAR2(10) — NOT NULL
- create_dept — VARCHAR2(5) — NOT NULL
- create_section — VARCHAR2(5) — NOT NULL
- create_user_id — VARCHAR2(10) — NOT NULL
- create_date — DA TE — NOT NULL
- update_dept — VARCHAR2(5) — NOT NULL
- update_section — VARCHAR2(5) — NOT NULL
- update_user_id — VARCHAR2(10) — NOT NULL
- update_date — DATE — NOT NULL
TBDACS_INIT_CODE
- idx — NUMBER — Primary key — NOT NULL
- rule_type (type) — VARCHAR2(10) — NOT NULL
- rule_desc (description) — VARCHAR2(100) — NOT NULL
- rule_code (code) — VARCHAR2(10) — NOT NULL
- create_dept — VARCHAR2(5)
- create_section — VARCHAR2(5)
- create_user_id — VARCHAR2(10)
- create_date — DATE
- update_dept — VARCHAR2(5)
- update_section — VARCHAR2(5)
- update_user_id — VARCHAR2(10)
- update_date — DATE
- Field
TBDACS_INIT_FUNC
- idx — NUMBER — Primary key — NOT NULL
- name — VARCHAR2(100) — NOT NULL
- start_dp_day — VARCHAR2(20) — NOT NULL
- end_dp_day — VARCHAR2(20) — NOT NULL
- cycle — VARCHAR2(20) — NOT NULL
- start_time — VARCHAR2(5) — NOT NULL
- create_dept — VARCHAR2(5) — NOT NULL
- create_section — VARCHAR2(5) — NOT NULL
- create_user_id — VARCHAR2(10) — NOT NULL
- create_date — DATE — NOT NULL
- update_dept — VARCHAR2(5) — NOT NULL
- update_section — VARCHAR2(5) — NOT NULL
- update_user_id — VARCHAR2(10) — NOT NULL
- update_date — DATE — NOT NULL
TBDACS_STD
- idx — NUMBER — Primary key — NOT NULL
- id — VARCHAR2(20)
- rev (revision) — VARCHAR2(10) — NOT NULL
- assign_code — VARCHAR2(20) — NOT NULL
- rule_desc (description) — VARCHAR2(500)
- rule_name (name) — VARCHAR2(100) — NOT NULL
- status — VARCHAR2(10)
- file_path — VARCHAR2(500)
- para1 (parameter1) — VARCHAR2(100)
- para2 (parameter2) — VARCHAR2(100)
- para3 (parameter3) — VARCHAR2(100)
- para4 (parameter4) — VARCHAR2(100)
- create_dept — VARCHAR2(5)
- create_section — VARCHAR2(5)
- create_user_id — VARCHAR2(10)
- create_date — DATE
- update_dept — VARCHAR2(5)
- update_section — VARCHAR2(5)
- update_user_id — VARCHAR2(10)
- update_date — DATE
TBDACS_STD_FILE
- idx — NUMBER — Primary key — NOT NULL
- check_rule_idx (TBDACS_STD PK) — NUMBER — Foreign key → TBDACS_STD.idx — NOT NULL
- FILE_PATH (file path) — VARCHAR(500)
TBDACS_STD_HIS
- idx — NUMBER — Primary key — NOT NULL
- check_rule_idx (TBDACS_STD PK) — NUMBER — Foreign key → TBDACS_STD.idx — NOT NULL
- assign_code — VARCHAR2(20) — NOT NULL
- status — VARCHAR2(10) — NOT NULL
- user_id — VARCHAR2(10) — NOT NULL
- user_dept — VARCHAR2(10) — NOT NULL
- insert_section — VARCHAR2(10) — NOT NULL
- insert_date — VARCHAR2(30) — NOT NULL
- comment — VARCHAR2(10) — NOT NULL — ARCHAR2(10) not nul
TBDACS_STD_REV
- check_rule_idx (TBDACS_STD PK) — NUMBER — Foreign key → TBDACS_STD.idx — NOT NULL
- id — VARCHAR2(20)
- rev (revision) — VARCHAR2(10) — NOT NULL
- assign_code — VARCHAR2(20) — NOT NULL
- rule_desc (description) — VARCHAR2(500)
- rule_name (name) — VARCHAR2(100) — NOT NULL
- status — VARCHAR2(10)
- file_path — VARCHAR2(500)
- para1 (parameter1) — VARCHAR2(100)
- para2 (parameter2) — VARCHAR2(100)
- para3 (parameter3) — VARCHAR2(100)
- para4 (parameter4) — VARCHAR2(100)
- create_dept — VARCHAR2(5)
- create_section — VARCHAR2(5)
- create_user_id — VARCHAR2(10)
- create_date — DATE
- update_dept — VARCHAR2(5)
- update_section — VARCHAR2(5)
- update_user_id — VARCHAR2(10)
- update_date — DATE