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