얼마들죠?
테이블 (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