bid_score_cozy

Tables (5)

bid_license_cozy (면허테이블)

  • seq (primary_key) — bigint(20) — Primary key — NOT NULL
  • bid_uniq (unique_key) — varchar(20)
  • license_code (Field) — varchar
  • rate (Field2) — varchar(10)
  • group (Field3) — int(1)
  • mf_code (Field4) — vhar(4)

bid_license_cozy_contract (면허테이블(상호실적))

  • seq (primary_key) — bigint(20) — Primary key — NOT NULL
  • bid_uniq (unique_key) — varchar(20)
  • license_code (Field) — varchar
  • rate (Field2) — varchar(10)
  • group (Field3) — int(1)
  • mf_code (Field4) — vhar(4)

cozy_avg_rate_info (업종평가비율)

  • seq (primary_key) — bigint(20) — Primary key — NOT NULL
  • license_code (Field) — varchar(20)
  • b_rate (Field2) — varchar(10)
  • u_rate (Field3) — varchar(10)
  • year (Field4) — char(4)
  • s_date (Field8) — date
  • rs_date (Field5) — date
  • e_date (Field6) — date
  • re_date (Field7) — date

cozy_calculation (입찰가격점수)

  • seq (primary_key) — int(11) — Primary key — NOT NULL
  • seq (primary_key2) — bigint(20) — Foreign key → cozy_information.seq — NOT NULL
  • contents (Field) — text
  • reg_dt (Field2) — datetime
  • calcu1 (Field3) — varchar(20)
  • calcu2 (Field4) — varchar(20)
  • calcu3 (Field5) — varchar(20)
  • calcu4 (Field8) — varchar(20)
  • bid_rate (Field6) — varchar(20)
  • limit_rate (Field7) — varchar(20)

cozy_information (별지)

  • seq (primary_key) — bigint(20) — Primary key — NOT NULL
  • cozy_code (Field) — varchar(20)
  • cozy_name (Field2) — varchar(50)
  • bid_section (Field3) — enum
  • p_place (Field4) — varchar(20)
  • p_date (Field5) — date
  • p_data (Field6) — longtext
  • resource (Field7) — varchar(10)
  • p_doc (Field8) — varchar(3)
  • p_section (Field9) — varchar(5)
  • goal_score (Field10) — varchar(10)