AdVator
테이블 (15)
견적 (estimate)
- estimateNumber (estimate_number) — Long — 기본 키 — NOT NULL
- request — Long
- apartNumber (apart_number) — Long — 외래 키 → 아파트.apartNumber — NOT NULL
광고 기간 (period)
- periodNumber (period_number) — Long — 기본 키 — NOT NULL
- period — String
광고 기간 (CopyOfperiod)
- periodNumber (period_number) — Long — 기본 키 — NOT NULL
- period — String
광고 업체(업체 마다 DB 생성 예정) (company_db)
- inquiryNumber (inquiry_number) — Long — 기본 키 — NOT NULL
- apartNumber (apart_number) — Long — 외래 키 → 아파트.apartNumber — NOT NULL
- periodNumber (period_number) — Long — 외래 키 → 광고 기간.periodNumber — NOT NULL
등급 (rating)
- ratingNumber (rating_number) — Long — 기본 키 — NOT NULL
- ratingName (rating_name) — String
등급 (CopyOfrating)
- ratingNumber (rating_number) — Long — 기본 키 — NOT NULL
- ratingName (rating_name) — String
사업 유형 (business)
- businessNumber (business_number) — Long — 기본 키 — NOT NULL
- businessName (business_name) — String
사업 유형 (CopyOfbusiness)
- businessNumber (business_number) — Long — 기본 키 — NOT NULL
- businessName (business_name) — String
사용자 (user)
- userNumber (user_number) — Long — 기본 키 — NOT NULL
- storeName (store_name) — String
- description — String
- author — String
- phone — String
- email — String
- personalAgree (personal_agree) — Boolean
- marketingAgree (marketing_agree) — Boolean
- businessNumber (business_number) — Long — 외래 키 → 사업 유형.businessNumber — NOT NULL
- industryNumber (industry_number) — Long — 외래 키 → 업종.industryNumber — NOT NULL
사용자 (CopyOfuser)
- userNumber (user_number) — Long — 기본 키 — NOT NULL
- storeName (store_name) — String
- description — String
- author — String
- phone — String
- email — String
- personalAgree (personal_agree) — Boolean
- marketingAgree (marketing_agree) — Boolean
- businessNumber (business_number) — Long — 외래 키 → 사업 유형.businessNumber — NOT NULL
- industryNumber (industry_number) — Long — 외래 키 → 업종.industryNumber — NOT NULL
- inquiryNumber (inquiry_number) — Long — 외래 키 → 광고 업체(업체 마다 DB 생성 예정).inquiryNumber — NOT NULL
아파트 (apartment)
- apartNumber (apart_number) — Long — 기본 키 — NOT NULL
- apartName (apart_name) — String
- apartCode (apart_code) — String
- lotAddress (lot_address) — String
- roadAddress (road_address) — String
- tvCount (tv_count) — Long
- unitPrice (unit_price) — Long
- totalPrice (total_price) — Long
- companyNumber (company_number) — Long — 외래 키 → 업체.companyNumber — NOT NULL
- ratingNumber (rating_number) — Long — 외래 키 → 등급.ratingNumber — NOT NULL
아파트 (CopyOfapartment)
- apartNumber (apart_number) — Long — 기본 키 — NOT NULL
- apartName (apart_name) — String
- apartCode (apart_code) — String
- lotAddress (lot_address) — String
- roadAddress (road_address) — String
- tvCount (tv_count) — Long
- unitPrice (unit_price) — Long
- totalPrice (total_price) — Long
- ratingNumber (rating_number) — Long — 외래 키 → 등급.ratingNumber — NOT NULL
업종 (industry)
- industryNumber (industry_number) — Long — 기본 키 — NOT NULL
- industryName (industry_name) — String
업종 (CopyOfindustry)
- industryNumber (industry_number) — Long — 기본 키 — NOT NULL
- industryName (industry_name) — String
업체 (company)
- companyNumber (company_number) — Long — 기본 키 — NOT NULL
- companyName (company_name) — String