bt-solution
Tables (6)
announcement_licenses
- announcement_id — BIGINT — Primary key — NOT NULL
- license_code — VARCHAR(20) — Primary key — NOT NULL
- seq_no — SMALLINT — NOT NULL
bt_report_inquiry_log
- seq — BIGINT — Primary key — NOT NULL
- member_id — VARCHAR(50) — NOT NULL
- ip_addr — VARCHAR(45) — NOT NULL
- biz_num — VARCHAR(10) — NOT NULL
- is_member — TINYINT(1) — NOT NULL
- reg_dt — DATETIME — NOT NULL
combo_win_prob
- cwp_id — bigserial
- announcement_id — int — NOT NULL
- company_id — int — NOT NULL
- win_combo_count — int
- win_probability — numeric(7, 4)
- in_range_count — int
- in_range_rate — numeric(7, 4)
- avg_dist — numeric(10, 5)
- prob_rank — int
- calculated_at — timestamp
issuers
- issuer_id — serial
- supply_code — varchar(20)
- supply_name — varchar(100) — NOT NULL
- created_at — timestamp
- new_supply_code — varchar(20)
nbid_multi_yega
- seq — bigint(20) — Primary key — NOT NULL
- bid_uniq — varchar(20) — NOT NULL — 공고유일코드
- cost — bigint(20) — 금액
- count — varchar(4) — 선택횟수
- select — enum('Y', 'N')
nbid_result_company
- seq — bigint(20) — Primary key — NOT NULL
- bid_dt — datetime — Primary key — NOT NULL — 입찰일
- bid_uniq — varchar(20) — NOT NULL — 공고유일코드
- bid_num — varchar(50) — NOT NULL — 공고번호
- company — varchar(40) — 업체명
- biz_num — char(10) — 사업자번호
- cost — decimal(16, 2) — NOT NULL — 투찰금액
- cheif — varchar(20) — 대표자
- sub_dt — datetime — 투찰일시
- rank — varchar(10) — 순위
- etc — varchar(50)
- sel_num — varchar(10) — 선택번호