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) — 선택번호