33 lines
655 B
YAML
33 lines
655 B
YAML
program_id: KYU02REG
|
|
db_type: SQLite
|
|
db_name: SALARY.db
|
|
|
|
db_tables:
|
|
- name: EMP_MASTER
|
|
columns:
|
|
- name: EMP_ID
|
|
type: CHAR(8)
|
|
primary_key: true
|
|
- name: EMP_NAME
|
|
type: VARCHAR(40)
|
|
- name: DEPT_CODE
|
|
type: CHAR(2)
|
|
- name: REGION_CODE
|
|
type: CHAR(2)
|
|
- name: CATEGORY_CODE
|
|
type: CHAR(3)
|
|
- name: BASE_SALARY
|
|
type: DECIMAL(9,0)
|
|
- name: HOURLY_RATE
|
|
type: DECIMAL(7,0)
|
|
- name: DEPENDENT_COUNT
|
|
type: SMALLINT
|
|
- name: STATUS
|
|
type: CHAR(1)
|
|
- name: UPDATED_AT
|
|
type: TIMESTAMP
|
|
|
|
subprograms:
|
|
- SUB02MSG
|
|
- SUB03END
|