ㅁㄴㅇ
Tables (6)
csv_file
- file_id — SERIAL
- file_path — VARCHAR(1024) — NOT NULL
- load_dt — TIMESTAMP
- total_rows — INTEGER
csv_row
- row_id — SERIAL
- file_id — INTEGER — Foreign key → csv_file.file_id — NOT NULL
- row_num — INTEGER — NOT NULL
- product_seq — VARCHAR(10)
- dev_model — VARCHAR(50)
- dev_seq — VARCHAR(50)
- ctn — VARCHAR(11)
- manufacturer — VARCHAR(50)
- device_model — VARCHAR(50)
- imei — VARCHAR(15)
- usim_model — VARCHAR(5)
- usim_seq — VARCHAR(8)
- iccid — VARCHAR(20)
- ces_code — VARCHAR(50)
- open_date — VARCHAR(14)
- customer_name — VARCHAR(50)
- remark — VARCHAR(200)
- bill_account_no — VARCHAR(12)
- sub_no — VARCHAR(12)
db_config
- config_id — SERIAL
- host — VARCHAR(128) — NOT NULL
- port — INTEGER — NOT NULL
- dbname — VARCHAR(128) — NOT NULL
- username — VARCHAR(128) — NOT NULL
- password — VARCHAR(128)
insert_log
- log_id — SERIAL
- log_timestamp — TIMESTAMP — NOT NULL
- csv_file_path — VARCHAR(1024)
- insert_count — INTEGER
- seq_start — INTEGER
- seq_end — INTEGER
- table_name — VARCHAR(256)
- db_host — VARCHAR(128)
- db_port — INTEGER
- db_name — VARCHAR(128)
tb_products
- product_seq — INTEGER
- page0 — VARCHAR(10)
- comm_type — VARCHAR(20)
- comm_fee — VARCHAR(50)
- reg_state — VARCHAR(20)
- dev_model — VARCHAR(50) — NOT NULL
- dev_seq — VARCHAR(50)
- ctn — VARCHAR(11)
- imei — VARCHAR(15) — NOT NULL
- usim_model — VARCHAR(5)
- usim_seq — VARCHAR(8)
- iccid — VARCHAR(20) — NOT NULL
- cse_id — VARCHAR(50)
- modem_date — VARCHAR(14)
- customer_name — VARCHAR(50)
- bill_recv_name — VARCHAR(50)
- bill_account_no — VARCHAR(12)
- sub_no — VARCHAR(12)
validation_result
- validation_id — SERIAL
- file_id — INTEGER — Foreign key → csv_file.file_id
- check_dt — TIMESTAMP
- is_passed — BOOLEAN
- empty_count — INTEGER
- format_count — INTEGER
- dup_csv_count — INTEGER
- dup_db_count — INTEGER
- gap_count — INTEGER