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)