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