supercar

테이블 (24)

Copy Of 찜하기 맵핑 (CopyOfMapping)

  • pdt_seq (seq) — Long — 외래 키 → 매물.pdt_seq — NOT NULL
  • user_seq (userSeq) — Long — 외래 키 → 회원.user_seq — NOT NULL

광고 (advertisement)

  • adt_seq (seq) — Long — 기본 키 — NOT NULL
  • adt_company_name (companyName) — String
  • adt_url (url) — String
  • adt_image_url (imageUrl) — String
  • adt_end_date (endDate) — String
  • adt_created_date (createdDate) — String
  • adt_Position (position) — String
  • adt_expire (expire) — ENUM

댓글 (comment)

  • cmt_seq (seq) — Long — 기본 키 — NOT NULL
  • cmt_contents (contents) — String — NOT NULL
  • like_count (likeCount) — Long
  • created_date (createdDate)
  • is_delete (isDelete) — Boolean

딜러 정보 (Dealer)

  • user_seq (userSeq) — Long — 외래 키 → 회원.user_seq — NOT NULL
  • usd_name (name) — String
  • usd_dealer_num (dealerNumber) — String
  • usd_attachment (Field) — 추후 문의테이블 확인 요망
  • usd_attachment2 (Field2) — 추후 문의테이블 확인 요망
  • com_seq (comSeq) — Long — 외래 키 → 상사.com_seq — NOT NULL
  • guild_seq (seq) — Long — 외래 키 → 조합.guild_seq — NOT NULL

매거진 (magazine)

  • mgz_seq (seq) — Long — 기본 키 — NOT NULL
  • mgz_title (title) — String
  • mgz_banner_image_url (bannerImageUrl) — String — NOT NULL
  • mgz_contents (contents) — String

매물 (Product)

  • pdt_seq (seq) — Long — 기본 키 — NOT NULL
  • pdt_title (title) — String
  • pdt_subtitle (subTitle) — String — NOT NULL
  • pdt_price (price) — integer
  • pdt_contents (contents) — String
  • pdt_performance_url (performanceUrl) — String
  • pdt_insurance_url (insuranceUrl) — String
  • pdt_created_date (createdDate) — String
  • pdt_status (status) — ENUM
  • pdt_appear (appear) — bool — 노출여부
  • pdt_rating (rating) — ENUM — 추후 우선순위
  • pdt_sell_type (Field)
  • user_seq (userSeq) — Long — 외래 키 → 딜러 정보.user_seq — NOT NULL

매물 사진 (product_image)

  • pdi_seq (seq) — Long — 기본 키 — NOT NULL
  • pdi_url (url) — String
  • pdt_seq (seq2) — Long — 외래 키 → 매물.pdt_seq — NOT NULL

매물 상세 정보 (Product_information)

  • pinf_seq (seq) — Long — 기본 키 — NOT NULL
  • pinf_car_number (carNumber) — String
  • pinf_registration_date (registrationDate) — String
  • pinf_year (Field)
  • pinf_cc (cc) — integer
  • pinf_transmission_type (transmissionType) — ENUM
  • pinf_mileage (mileage) — integer
  • pinf_color (color) — String
  • pinf_accident_history (accidentHistory) — bool
  • pinf_fuel (fuel) — ENUM
  • pdt_seq (seq2) — Long — 외래 키 → 매물.pdt_seq — NOT NULL
  • model_seq (seq3) — Long — 외래 키 → 모델.model_seq — NOT NULL

매물 카테고리 맵핑 (CopyOfCategory)

  • pdt_seq (seq) — Long — 외래 키 → 매물.pdt_seq — NOT NULL
  • ca_seq (seq2) — integer — 외래 키 → 카테고리.ca_seq — NOT NULL

모델 (Model)

  • model_seq (seq) — Long — 기본 키 — NOT NULL
  • model_name (transmissionType) — ENUM
  • model_trim (mileage) — integer
  • brand_seq (seq2) — Long — 외래 키 → 브랜드.brand_seq — NOT NULL

문의 (Inquiry)

  • pinq_seq (seq) — Long — 기본 키 — NOT NULL
  • user_seq (seq2) — Long — 외래 키 → 회원.user_seq — NOT NULL

문의 (기타 문의) (etcetera_Inquiry)

  • einq_seq (seq) — Long — 기본 키 — NOT NULL
  • pinq_title (title) — String
  • pinq_contents (contents) — String — NOT NULL
  • pinq_attachment (attachmentUrl) — String
  • pinq_status (status) — ENUM
  • pinq_created_date (createdDate) — String
  • pinq_type (type) — ENUM

문의 (광고 문의) (advertisment_Inquiry)

  • adinq_seq (seq) — Long — 기본 키 — NOT NULL
  • pinq_title (title) — String
  • pinq_contents (contents) — String — NOT NULL
  • pinq_attachment (attachmentUrl) — String
  • pinq_status (status) — ENUM
  • pinq_created_date (createdDate) — String
  • pinq_type (type) — ENUM

문의(딜러등록) (Dealer_Inquiry)

  • dinq_seq (seq) — Long — 기본 키 — NOT NULL
  • pinq_title (title) — String
  • pinq_contents (contents) — String — NOT NULL
  • pinq_attachment (attachmentUrl) — String
  • pinq_status (status) — ENUM
  • pinq_created_date (createdDate) — String
  • pinq_type (type) — ENUM

문의(제휴업체등록) (Affiliates_Inquiry)

  • afinq_seq (seq) — Long — 기본 키 — NOT NULL
  • pinq_title (title) — String
  • pinq_contents (contents) — String — NOT NULL
  • pinq_attachment (attachmentUrl) — String
  • pinq_status (status) — ENUM
  • pinq_created_date (createdDate) — String
  • pinq_type (type) — ENUM

문의(차량 등록) (Product_Inquiry)

  • pinq_seq (seq) — Long — 기본 키 — NOT NULL
  • pinq_title (title) — String
  • pinq_contents (contents) — String — NOT NULL
  • pinq_attachment (attachmentUrl) — String
  • pinq_status (status) — ENUM
  • pinq_created_date (createdDate) — String
  • pinq_type (type) — ENUM

브랜드 (Brand)

  • brand_seq (seq) — Long — 기본 키 — NOT NULL
  • brand_name (fuel) — String

상담신청 (ConsultRequest)

  • user_seq (userSeq) — Long — 외래 키 → 회원.user_seq — NOT NULL
  • pdt_seq (seq) — Long — 외래 키 → 매물.pdt_seq — NOT NULL
  • status — ENUM

상사 (Company)

  • com_seq (comSeq) — Long — 기본 키 — NOT NULL
  • com_name (name) — String
  • com_address (dealerNumber) — String
  • com_reg_num (comRegNum)
  • com_phone (Field2)

자료실 (download)

  • dwl_seq (seq) — Long — 기본 키 — NOT NULL
  • dwl_title (title) — String
  • dwl_contents (contents) — String — NOT NULL
  • dwl_approve (approve) — int
  • dwl_disapprove (disapprove) — int
  • dwl_view_count (viewCount) — Long
  • dwl_attachment_url (attachmentUrl) — String
  • dwl_created_date (createdDate) — String

조합 (Guild)

  • guild_seq (seq) — Long — 기본 키 — NOT NULL
  • guild_name (name) — String
  • guild_address (address) — String — NOT NULL
  • guild_reg_num (Field)
  • guild_phone (Field2)

카테고리 (Category)

  • ca_seq (seq) — integer — 기본 키 — NOT NULL
  • ca_name (categoryName) — String

파파라치 (paparazzi)

  • prz_seq (seq) — Long — 기본 키 — NOT NULL
  • prz_title (title) — String
  • prz_contents (contents) — String — NOT NULL
  • prz_approve (approve) — int
  • prz_disapprove (disapprove) — int
  • prz_view_count (viewCount) — Long
  • prz_created_date (createdDate) — String
  • prz_rating (rating) — ENUM

회원 (User)

  • user_seq (userSeq) — Long — 기본 키 — NOT NULL
  • user_id (userId) — String
  • user_password (userPassword) — String
  • user_nickname (userNickname) — String — NOT NULL
  • user_email (userEmail) — String
  • user_phone_number (userPhoneNumber) — String
  • user_rating (userRating) — ENUM
  • user_role (roler) — ENUM
  • user_created_date (createdDate) — String