poen

테이블 (29)

FCM 토큰 (notification_token)

  • uuid_notification_token — binary(16) — 기본 키 — NOT NULL
  • DTYPE — varchar(31) — NOT NULL
  • device_id — varchar(255) — NOT NULL
  • device_type — enum('ANDROID','IOS','OTHERS','WEB') — NOT NULL
  • fcm_token — varchar(255) — NOT NULL
  • reg_date — datetime(6) — NOT NULL
  • member_uuid — binary(16) — 외래 키 → base_member.uuid_member — NOT NULL

base_board

  • uuid_base_board — binary(16) — 기본 키 — NOT NULL
  • dtype — varchar(31) — NOT NULL
  • content — text — NOT NULL
  • deleted_date — datetime(6)
  • hit — bigint
  • is_deleted — bit(1) — NOT NULL
  • modified_date — datetime(6) — NOT NULL
  • reg_date — datetime(6) — NOT NULL
  • title — varchar(255) — NOT NULL

base_document

  • uuid_base_document — binary(16) — 기본 키 — NOT NULL
  • dtype — varchar(31) — NOT NULL
  • filename — varchar(255)
  • filepath — varchar(255)
  • reg_date — datetime(6) — NOT NULL
  • url — varchar(255)

base_image

  • uuid_base_image — binary(16) — 기본 키 — NOT NULL
  • dtype — varchar(31) — NOT NULL
  • filename — varchar(255)
  • original_filepath — varchar(255)
  • original_height — int
  • original_url — varchar(255)
  • original_width — int
  • reg_date — datetime(6) — NOT NULL
  • resized_filepath — varchar(255)
  • resized_height — int
  • resized_url — varchar(255)
  • resized_width — int

base_member

  • uuid_member — binary(16) — 기본 키 — NOT NULL
  • birthdate — date
  • deleted_date — datetime(6)
  • gender — enum('FEMALE','MALE')
  • is_deleted — bit(1) — NOT NULL
  • name — varchar(10)
  • nickname — varchar(10)
  • phone_number — varchar(20)
  • reg_date — datetime(6) — NOT NULL
  • updated_date — datetime(6) — NOT NULL
  • general_member_uuid — binary(16) — 외래 키 → general_member.uuid_general_member

general_member

  • uuid_general_member — binary(16) — 기본 키 — NOT NULL
  • email — varchar(50)
  • identifier — varchar(20) — NOT NULL
  • is_deleted — bit(1) — NOT NULL
  • password — varchar(100)

고장코드(엑셀 데이터) (dtc_code)

  • uuid_dtc_code — binary(16) — 기본 키 — NOT NULL
  • car_model — varchar(20) — NOT NULL
  • car_year — int
  • code_status — varchar(255) — NOT NULL
  • code_value — varchar(10) — NOT NULL
  • reg_date — datetime(6) — NOT NULL
  • updated_date — datetime(6) — NOT NULL

고장코드(엑셀데이터) 업데이트 정보 (dtc_code_status)

  • id_dtc_code_status — bigint — 기본 키 — NOT NULL
  • updated_date — datetime(6) — NOT NULL

공지사항 (notice)

  • uuid_base_board — binary(16) — 외래 키 → base_board.uuid_base_board — NOT NULL

관리자 (admin)

  • uuid_member — binary(16) — 외래 키 → base_member.uuid_member — NOT NULL

권한 (permission)

  • id_permission — bigint — 기본 키 — NOT NULL
  • permission_type — varchar(10) — NOT NULL

리프레시 토큰 (refresh_token)

  • uuid_refresh_token — binary(16) — 기본 키 — NOT NULL
  • expires_at — datetime(6) — NOT NULL
  • refresh_token_value — varchar(500) — NOT NULL
  • member_uuid — binary(16) — 외래 키 → base_member.uuid_member — NOT NULL

문의게시판(답변) (answer)

  • uuid_answer — binary(16) — 기본 키 — NOT NULL
  • content — text — NOT NULL
  • reg_date — datetime(6) — NOT NULL
  • question_uuid — binary(16) — 외래 키 → 문의게시판(문의).uuid_base_board — NOT NULL
  • updated_date — datetime(6) — NOT NULL

문의게시판(문의) (question)

  • uuid_base_board — binary(16) — 외래 키 → base_board.uuid_base_board — NOT NULL
  • is_answered — bit(1) — NOT NULL
  • member_uuid — binary(16) — 외래 키 → 회원 (판매자, 구매자).uuid_member — NOT NULL
  • question_type — enum('EXAMPLE') — NOT NULL

배터리 (battery)

  • uuid_battery — binary(16) — 기본 키 — NOT NULL
  • car_manufacturer — varchar(30) — NOT NULL
  • car_model — varchar(20) — NOT NULL
  • car_no — varchar(30)
  • car_year — int
  • deleted_date — datetime(6)
  • is_deleted — bit(1) — NOT NULL
  • product_no — varchar(30)
  • production_date — date
  • qrcode — varchar(50)
  • reg_date — datetime(6)
  • rom_id — varchar(10)
  • member_uuid — binary(16) — 외래 키 → 회원 (판매자, 구매자).uuid_member — NOT NULL

배터리 고장코드 (battery_failure_code)

  • uuid_battery_failure_code — binary(16) — 기본 키 — NOT NULL
  • battery_measurement_uuid — binary(16) — NOT NULL
  • code — varchar(10)
  • code_name — varchar(50)
  • priority — int — NOT NULL
  • status — varchar(5)

배터리 이미지 (battery_image)

  • uuid_base_image — binary(16) — 외래 키 → base_image.uuid_base_image — NOT NULL
  • battery_uuid — binary(16) — NOT NULL

배터리 진단 (battery_measurement)

  • uuid_battery_measurement — binary(16) — 기본 키 — NOT NULL
  • breakage — varchar(255)
  • car_manufacturer — varchar(30) — NOT NULL
  • car_model — varchar(20) — NOT NULL
  • car_no — varchar(30)
  • car_year — int
  • cell_deviation — int
  • company — varchar(30) — NOT NULL
  • deleted_date — datetime(6)
  • failure_code — varchar(1)
  • identifier — varchar(255)
  • is_deleted — bit(1) — NOT NULL
  • moisture — varchar(255)
  • note — varchar(255)
  • pollution — varchar(255)
  • price — int
  • product_no — varchar(30)
  • production_date — date
  • qrcode — varchar(50)
  • reg_date — datetime(6) — NOT NULL
  • representative_image_uuid — binary(16)
  • rom_id — varchar(10)
  • sale_status — enum('FINISHED','NOT_REGISTERED','ON_SALE','RESERVED') — NOT NULL
  • sequence — int
  • soc — int
  • soh — int
  • updated_date — datetime(6) — NOT NULL
  • battery_uuid — binary(16) — 외래 키 → 배터리.uuid_battery — NOT NULL
  • member_uuid — binary(16) — 외래 키 → 회원 (판매자, 구매자).uuid_member — NOT NULL

배터리 진단 데이터 (battery_measurement_data)

  • uuid_battery_measurement_data — binary(16) — 기본 키 — NOT NULL
  • battery_measurement_uuid — binary(16) — NOT NULL
  • is_battery_cell_voltage — bit(1)
  • name — varchar(20) — NOT NULL
  • measurement_order — bigint — NOT NULL
  • result — varchar(50)
  • unit — varchar(10)

배터리 진단 보고서 (battery_measurement_overview)

  • uuid_battery_measurement_overview — binary(16) — 기본 키 — NOT NULL
  • battery_measurement_uuid — binary(16) — NOT NULL
  • name — varchar(20) — NOT NULL
  • overview_no — int — NOT NULL
  • result — varchar(50)
  • status — enum('미흡','불량','양호','우수')
  • unit — varchar(10)

배터리 진단 파일 (통신한 바이너리 데이터 저장용) (battery_measurement_file)

  • uuid_base_document — binary(16) — 외래 키 → base_document.uuid_base_document — NOT NULL
  • battery_uuid — binary(16) — 외래 키 → 배터리.uuid_battery — NOT NULL

사용자 권한 (member_permission)

  • permission_id — bigint — 외래 키 → 권한.id_permission — NOT NULL
  • member_uuid — binary(16) — 외래 키 → base_member.uuid_member — NOT NULL

알림 (notification)

  • uuid_notification — binary(16) — 기본 키 — NOT NULL
  • DTYPE — varchar(31) — NOT NULL
  • body — varchar(255) — NOT NULL
  • deleted_date — datetime(6)
  • is_deleted — bit(1) — NOT NULL
  • is_read — bit(1) — NOT NULL
  • read_date — datetime(6)
  • reg_date — datetime(6) — NOT NULL
  • title — varchar(255) — NOT NULL
  • link_to — binary(16) — NOT NULL
  • notification_type — enum('INQUIRY','QNA') — NOT NULL
  • member_uuid — binary(16) — 외래 키 → base_member.uuid_member — NOT NULL

연식 (car_year)

  • uuid_car_year — binary(16) — 기본 키 — NOT NULL
  • is_active — bit(1) — NOT NULL
  • year — int — NOT NULL
  • car_model_uuid — binary(16) — 외래 키 → 차종.uuid_car_model — NOT NULL

이메일 인증 코드 (email_authentication)

  • uuid_email_authentication — binary(16) — 기본 키 — NOT NULL
  • email — varchar(50) — NOT NULL
  • expires_at — datetime(6) — NOT NULL
  • is_validated — bit(1) — NOT NULL
  • reg_date — datetime(6) — NOT NULL
  • verification_code — varchar(6) — NOT NULL

제조사 (car_manufacturer)

  • uuid_car_manufacturer — binary(16) — 기본 키 — NOT NULL
  • is_active — bit(1) — NOT NULL
  • manufacturer — varchar(30) — NOT NULL

차종 (car_model)

  • uuid_car_model — binary(16) — 기본 키 — NOT NULL
  • is_active — bit(1) — NOT NULL
  • model — varchar(20) — NOT NULL
  • car_manufacturer_uuid — binary(16) — 외래 키 → 제조사.uuid_car_manufacturer — NOT NULL

판매자에게 문의 (inquiry)

  • uuid_inquiry — binary(16) — 기본 키 — NOT NULL
  • battery_car_manufacturer — varchar(30) — NOT NULL
  • battery_car_model — varchar(20) — NOT NULL
  • battery_identifier — varchar(255) — NOT NULL
  • content — text — NOT NULL
  • member_buyer_name — varchar(10) — NOT NULL
  • member_buyer_phone_number — varchar(20) — NOT NULL
  • member_seller_name — varchar(30) — NOT NULL
  • reg_date — datetime(6) — NOT NULL
  • member_buyer_uuid — binary(16) — 외래 키 → 회원 (판매자, 구매자).uuid_member — NOT NULL
  • member_seller_uuid — binary(16) — 외래 키 → 회원 (판매자, 구매자).uuid_member — NOT NULL

회원 (판매자, 구매자) (member)

  • uuid_member — binary(16) — 외래 키 → base_member.uuid_member — NOT NULL
  • default_address — varchar(255) — NOT NULL
  • detail_address — varchar(255)
  • zipcode — varchar(5) — NOT NULL
  • business_account_bank — enum('KDB산업은행','IBK기업은행','KB국민은행','수협은행','NH농협은행','우리은행','SC제일은행','한국씨티은행','대구은행','부산은행','광주은행','제주은행','전북은행','경남은행','하나은행','신한은행','케이뱅크','카카오뱅크')
  • business_account_number — varchar(255)
  • business_default_address — varchar(255)
  • business_detail_address — varchar(255)
  • business_zipcode — varchar(255)
  • business_name — varchar(30)
  • business_number — varchar(10)
  • business_open_date — date
  • business_representative_name — varchar(10)
  • deleted_reason — varchar(255)