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