얼마들죠?

테이블 (7)

tblHowMuchBldDetail (Untitled4)

  • detailID (상세ID) — 기본 키 — NOT NULL
  • bldId (Key2) — 외래 키 → tblHowMuchBldInfo.bldID — NOT NULL
  • name (Field)
  • location (Field2)
  • area (Field3)
  • round (Field4)
  • height (Field5)
  • comDsc (전용여부) — Enum
  • Field7
  • Field8

tblHowMuchBldInfo (Untitled3)

  • bldID (Key) — 기본 키 — NOT NULL
  • workId (작업물아이디) — number — 외래 키 → tblHowMuchWorkSheet.workID — NOT NULL
  • floor (층수) — VARCHAR(5)
  • area (Field2)
  • height (Field3)
  • name (Field4)
  • in_perimeter (Field5)
  • out_perimeter (Field)
  • (Field6)

tblHowMuchFacadeInfo (Untitled6)

  • facadeID (Key) — 기본 키 — NOT NULL
  • workID (작업물아이디) — number — 외래 키 → tblHowMuchWorkSheet.workID — NOT NULL
  • name (Field)
  • area (Field2)
  • option (Field3)

tblHowMuchLandInfo (Untitled2)

  • landID (Key) — 기본 키 — NOT NULL
  • workId (작업물아이디) — number — 외래 키 → tblHowMuchWorkSheet.workID — NOT NULL
  • addr (주소) — VARCHAR(30)
  • center (Field2)
  • area (Field3)
  • uname (Field4)
  • jiga (Field5)
  • jimok (Field)
  • maxBcRate (Field6)
  • maxVlRate (Field7)
  • landUsage (Field8)

tblHowMuchOpenArea (Untitled5)

  • openID (Key) — 기본 키 — NOT NULL
  • detailID (상세ID) — 외래 키 → tblHowMuchBldDetail.detailID — NOT NULL
  • name (Field)
  • area (Field2)
  • used (Field3)
  • amount (Field4)

tblHowMuchWindowInfo (Untitled7)

  • WindowID (Key) — 기본 키 — NOT NULL
  • workID (작업물아이디) — number — 외래 키 → tblHowMuchWorkSheet.workID — NOT NULL
  • name (Field)
  • amount (Field2)
  • locate (Field3)
  • frameA (Field4)
  • frameR (Field5)
  • frameSpec (Field6)
  • glassA (Field7)
  • glassR (Field8)
  • glassSpec (Field9)
  • exterior (Field10) — bool

tblHowMuchWorkSheet (Untitled)

  • workID (작업물아이디) — number — 기본 키 — NOT NULL
  • regDt (Field) — DATE
  • upDt (Field2) — Date
  • userId (작성자) — VARCHAR
  • Field3