ReGoCar

Tables (6)

Car_Tip (사고차량 꿀팁)

  • unique_id (고유 번호) — text — Primary key — NOT NULL
  • content (내용) — text
  • thumbnail (썸네일 이미지) — image
  • image (내용 이미지) — image
  • titel (제목) — text
  • write_at (작성일자) — date

Inquiry (문의)

  • title (제목) — text
  • category_type (ACCOUNT, PAYMENT, PROJECT, DISPUTE, NO-SHOW, APP, POLICY, PARTNERSHIP) — CATEGORY_TYPE
  • content (문의 내용)

Notice (공지사항)

  • title (제목) — text
  • content (공지 내용) — text

Term (약관)

  • service (서비스 약관) — text
  • personal (개인정보 처리방침) — text
  • third (제 3자 정보 제공 동의) — text

User (유저)

  • unique_id (고유 번호) — text — Primary key — NOT NULL
  • init_password (설정 비밀번호) — text
  • name (이름) — text
  • phone (전화번호) — num
  • user_state (ACTIVE, SOCIAL_WAIT, BAN, WITHDRAWAL, DENY, REQUEST) — USER_STATE
  • user_type (USER, ADMIN, DEALOR, DEALER_DIRECT) — USER_TYPE
  • profile_image (프로필 이미지) — image<list>
  • worker_certificate_number (종사원증의 고유 식별 번호) — text
  • worker_certificate_file (종사원증 파일) — file
  • trading_company_name (매매상사명) — text
  • address (주소) — text
  • address_detail (상세 주소) — text
  • introduction_text (인사말) — text
  • login_type (KAKAO, NAVER, APPLE, GOOGLE) — LOGIN_TYPE
  • dealor_type (REPAIR_COMPANY, TRADING_MEMBER, EXPORTER, REGULAR_MEMBER) — DEALOR_TYPE
  • user_book_mark (북마크) — Vehicle_Direct_Listing<list>

Vehicle_Direct_Listing (차량 직거래 셀프 등록)

  • unique_id (고유 번호) — text — Primary key — NOT NULL
  • vehicle_name (차량명) — text
  • registration_date (등록날짜) — date
  • image (차량 이미지) — image<list>
  • license_plate (차량 번호) — text
  • Sell (판매 여부) — boolean
  • manufacturer (제조사) — text
  • model (모델) — text
  • submodel (세부모델) — text
  • year (연식) — date
  • mileage (주행거리) — num
  • engine_displacement (배기량) — num
  • exterior_interior_type (SUNROOF, HEADLAMP_HID, HEADLAMP_LED, POWER_FOLDING_SIDE_MIRROR, HIPASS, HEATED_STEERING_WHEEL, POWER_ADJUSTABLE_STEERING_WHEEL, ECM_ROOM_MIRROR, POWER_TAILGATE, PADDLE_SHIFT) — EXTERIOR_INTERIOR
  • safety_type (ELECTRONIC_CONTROL_SUSPENSION_ECS, FRONT_PARKING_SENSOR, REAR_PARKING_SENSOR, BLIND_SPOT_MONITORING_SYSTEM, REAR_VIEW_CAMERA, AROUND_VIEW_MONITOR_360) — SAFETY
  • convenience_multimedia_type (CRUISE_CONTROL_STANDARD, CRUISE_CONTROL_ADAPTIVE, HEAD_UP_DISPLAY_HUD, SMART_KEY, NAVIGATION, AUTO_LIGHTS, BLUETOOTH) — CONVENIENCE_MULTIMEDIA
  • seat_type (POWER_SEAT_DRIVER, POWER_SEAT_PASSENGER, POWER_SEAT_REAR, HEATED_SEAT_FRONT, HEATED_SEAT_REAR, VENTILATED_SEAT_DRIVER, VENTILATED_SEAT_PASSENGER, VENTILATED_SEAT_REAR) — SEAT
  • unique_features (고유 옵션) — text<list>
  • price_type (PRICE_REGOCA, PRICE_NEW_CAR, PRICE_ALD_CAR) — PRICE_TYPE
  • price_content (가격 설명) — text
  • check_image (점검이미지) — image
  • inspection_result_type (NORMAL, GOOD, FAULTY, REPLACEMENT_REQUIRED, NOT_APPLICABLE) — INSPECTION_RESULT
  • inspection_category (SELF_DIAGNOSIS, POWER_UNIT, POWER_TRANSMISSION_STEERING_BRAKE, ELECTRICAL_AND_OTHERS) — INSPECTION_CATEGORY
  • inspection_category_name (성능 점검 이름) — text
  • safety_driving_test (DRIVING_STABILITY, STEERING_PERFORMANCE, SUSPENSION_AND_UNDERBODY, BRAKE_SYSTEM, ENGINE_AND_TRANSMISSION, OTHERS) — SAFETY_DRIVING_TEST
  • regoca_inspection (EXTERIOR, UNDERBODY, CONSUMABLES, ELECTRICAL_CONVENIENCE) — REGOCA_INSPECTION
  • Field
  • user (유저) — USER — Foreign key → User.unique_id — NOT NULL