spation

Tables (50)

announcement

  • id — bigint
  • created_at — datetime(6) — NOT NULL
  • updated_at — datetime(6)
  • content — longtext
  • created_by — bigint — NOT NULL
  • title — varchar(255)
  • updated_by — bigint — NOT NULL
  • operator_id — bigint
  • is_urgent — bit — NOT NULL
  • target_type — varchar(255)

announcement_assignment

  • id — bigint
  • created_at — datetime(6) — NOT NULL
  • updated_at — datetime(6)
  • announcement_id — bigint — NOT NULL
  • venue_id — bigint
  • operator_id — bigint

announcement_attachment_file

  • id — bigint
  • created_at — datetime(6) — NOT NULL
  • updated_at — datetime(6)
  • announcement_id — bigint — NOT NULL
  • file_id — bigint — NOT NULL

announcement_checked

  • id — bigint
  • created_at — datetime(6) — NOT NULL
  • updated_at — datetime(6)
  • announcement_id — bigint
  • user_id — bigint

attendance

  • id — bigint
  • created_at — datetime(6) — NOT NULL
  • updated_at — datetime(6)
  • base_date — date — NOT NULL
  • begin — datetime(6) — NOT NULL
  • end — datetime(6)
  • user_id — bigint — NOT NULL
  • venue_id — bigint — NOT NULL

attendance_blacklist

  • id — bigint
  • created_at — datetime(6) — NOT NULL
  • updated_at — datetime(6)
  • description — longtext
  • type — varchar(255)
  • user_id — bigint — NOT NULL

auth_token_info

  • id — bigint
  • created_at — datetime(6) — NOT NULL
  • updated_at — datetime(6)
  • access_valid_time — bigint — NOT NULL
  • refresh_valid_time — bigint — NOT NULL

base_inquiry

  • id — bigint — PK' primary ke
  • site — varchar(64) — NOT NULL — 요청 사이트
  • type — varchar(64) — NOT NULL — 요청 구분(ESTIMATE|SERVICE)
  • request — text — NOT NULL — 요청 내역
  • terms_agreed — tinyint(1) — 개인정보 이용동의
  • company_name — varchar(512) — 회사명
  • address — varchar(1024) — 주소
  • name — varchar(512) — 연락처 이름
  • phone — varchar(512) — 연락처 전화번호
  • email — varchar(512) — 연락처 이메일
  • device — varchar(512) — 접속 디바이스
  • referer — varchar(512) — 유입 경로
  • keywords — varchar(512) — 유입 검색어
  • venue_id — bigint — venue.id
  • client_id — bigint — cleanier_user.id
  • created_at — datetime(6) — NOT NULL — 생성일시

base_inquiry_file

  • inquiry_id — bigint — NOT NULL — base_inquiry.id
  • file_id — bigint — NOT NULL — file.id

bm_inquiry

  • id — bigint — PK' primary ke
  • scope — varchar(64) — NOT NULL — 서비스 범위
  • address — varchar(1024) — NOT NULL — 주소
  • name — varchar(255) — NOT NULL — 이름
  • phone — varchar(255) — NOT NULL — 전화번호
  • terms_agreed — tinyint(1) — NOT NULL — 약관동의
  • referrer — varchar(255) — 유입경로
  • device — varchar(255) — 접속디바이스
  • keywords — varchar(255) — 검색어
  • created_at — datetime(6) — NOT NULL — 생성일시

building

  • id — bigint
  • created_at — datetime(6) — NOT NULL
  • updated_at — datetime(6)
  • address — varchar(255) — NOT NULL
  • bjdong_code — varchar(5) — NOT NULL
  • bun — varchar(4) — NOT NULL
  • is_deleted — bit — NOT NULL
  • ji — varchar(4) — NOT NULL
  • latitude — double
  • longitude — double
  • name — varchar(255)
  • sigungu_code — varchar(5) — NOT NULL

cleanier_contract

  • id — bigint
  • created_at — datetime(6) — NOT NULL
  • updated_at — datetime(6)
  • building_address — varchar(255) — NOT NULL
  • building_detailed_address — varchar(255)
  • building_picture — varchar(255)
  • contract_begin — date — NOT NULL
  • contract_end — date — NOT NULL
  • days_per_week — bigint — NOT NULL
  • email_billing — varchar(255) — NOT NULL
  • email_tax_invoice — varchar(255) — NOT NULL
  • memo — varchar(1024)
  • payment_date — bigint — NOT NULL
  • periodic_friday — bit — NOT NULL
  • periodic_monday — bit — NOT NULL
  • periodic_saturday — bit — NOT NULL
  • periodic_sunday — bit — NOT NULL
  • periodic_thursday — bit — NOT NULL
  • periodic_tuesday — bit — NOT NULL
  • periodic_wednesday — bit — NOT NULL
  • service_begin — date — NOT NULL
  • space_type — varchar(255)
  • cleanier_user_id — bigint — NOT NULL

cleanier_login

  • id — bigint
  • created_at — datetime(6) — NOT NULL
  • updated_at — datetime(6)
  • access_expiration — datetime(6) — NOT NULL
  • access_token — varchar(255) — NOT NULL
  • refresh_expiration — datetime(6) — NOT NULL
  • refresh_token — varchar(255) — NOT NULL
  • user_id — bigint — NOT NULL

cleanier_manager

  • id — bigint
  • manager_email — varchar(255)
  • manager_memo — varchar(1024)
  • name — varchar(255)
  • phone — varchar(255)
  • manager_rank — varchar(255)
  • cleanier_contract_id — bigint — NOT NULL

cleanier_notice

  • id — bigint — PK' primary ke
  • category — varchar(64) — NOT NULL — 카테고리
  • from_id — bigint — NOT NULL — 보낸 사람
  • title — varchar(256) — NOT NULL — 제목
  • content — varchar(2000) — 내용
  • is_checked — tinyint(1) — NOT NULL — 확인 여부
  • checked_at — datetime(6) — 확인 시간
  • user_id — bigint — NOT NULL — 대상(cleanier_user.id)
  • created_at — datetime(6) — NOT NULL — 생성 시간

cleanier_runtime_constant

  • id — bigint
  • created_at — datetime(6) — NOT NULL
  • updated_at — datetime(6)
  • key_string — varchar(255) — NOT NULL
  • value_string — varchar(255) — NOT NULL

cleanier_user

  • id — bigint
  • created_at — datetime(6) — NOT NULL
  • updated_at — datetime(6)
  • address — varchar(255) — NOT NULL
  • company_name — varchar(255)
  • company_registration_number — varchar(12)
  • detailed_address — varchar(255)
  • email — varchar(255) — NOT NULL
  • emergency_number — varchar(255)
  • identifier — varchar(255) — NOT NULL
  • memo — varchar(1024)
  • name — varchar(255) — NOT NULL
  • password — varchar(255) — NOT NULL
  • password_state — bit — NOT NULL
  • phone_number — varchar(255) — NOT NULL
  • subsequent_business_place_number — varchar(4)
  • user_type — varchar(255) — NOT NULL
  • venue_id — bigint
  • operator_id — bigint — operator.id
  • cleanier_user_role — bigint — NOT NULL
  • login_state — bit — NOT NULL

cleanier_user_role

  • id — bigint
  • description — varchar(255) — NOT NULL
  • name — varchar(255) — NOT NULL

client

  • id — bigint
  • created_at — datetime(6) — NOT NULL
  • updated_at — datetime(6)
  • business_category — varchar(255)
  • ceo_email — varchar(255)
  • ceo_name — varchar(255)
  • company_name — varchar(255) — NOT NULL
  • company_registration_number — varchar(10) — NOT NULL
  • operator_id — bigint — NOT NULL

client_manager

  • id — bigint
  • created_at — datetime(6) — NOT NULL
  • updated_at — datetime(6)
  • manager_email — varchar(255)
  • manager_name — varchar(255) — NOT NULL
  • manager_phone — varchar(255) — NOT NULL
  • client_id — bigint — NOT NULL

contract

  • id — bigint
  • created_at — datetime(6) — NOT NULL
  • updated_at — datetime(6)
  • document_id — varchar(255) — NOT NULL
  • participant_user_id — bigint — NOT NULL
  • contract_template — varchar(255) — NOT NULL
  • requester_operator_id — bigint — NOT NULL

contract_event

  • id — bigint
  • created_at — datetime(6) — NOT NULL
  • updated_at — datetime(6)
  • document_id — varchar(255) — NOT NULL
  • document_requester_email — varchar(255) — NOT NULL
  • event_type — varchar(255) — NOT NULL

file

  • id — bigint
  • created_at — datetime(6) — NOT NULL
  • updated_at — datetime(6)
  • is_deleted — bit — NOT NULL
  • extension — varchar(255)
  • name — longtext — NOT NULL
  • path — longtext — NOT NULL
  • size — bigint — NOT NULL
  • thumbnail_path — longtext
  • type — varchar(255) — NOT NULL
  • password — varchar(50)

floor

  • id — bigint
  • created_at — datetime(6) — NOT NULL
  • updated_at — datetime(6)
  • display_name — varchar(255) — NOT NULL
  • gb_code — bigint — NOT NULL
  • is_deleted — bit — NOT NULL
  • is_immutable — bit — NOT NULL
  • is_visible — bit — NOT NULL
  • level — bigint
  • name — varchar(255) — NOT NULL
  • building_id — bigint — NOT NULL

general_inquiry

  • id — bigint
  • created_at — datetime(6) — NOT NULL
  • updated_at — datetime(6)
  • area_id — bigint — NOT NULL
  • area_name — varchar(255) — NOT NULL
  • category_id — bigint — NOT NULL
  • category_name — varchar(255) — NOT NULL
  • device — varchar(255) — NOT NULL
  • email — varchar(255) — NOT NULL
  • keywords — varchar(255)
  • memo — varchar(1024)
  • name — varchar(255) — NOT NULL
  • phone — varchar(255) — NOT NULL
  • provision_agreed — bit — NOT NULL
  • referrer — varchar(255)
  • company_name — varchar(255)

inquiry_chatting_file

  • message_id — bigint — NOT NULL — inquiry_chatting_message.id
  • file_id — bigint — NOT NULL — file.id

inquiry_chatting_group

  • id — bigint — PK' primary ke
  • venue_id — bigint — NOT NULL — 지점(venue.id)
  • category — varchar(64) — NOT NULL — 구분(채팅/서비스 신청)
  • title — varchar(256) — NOT NULL — 제목
  • status — int — NOT NULL — 대화 상태(시작/진행/완료)
  • client_id — bigint — 생성자(cleanier_user.id)
  • manager_id — bigint — 생성자(user.id)
  • created_at — datetime — NOT NULL — 생성일시
  • updated_at — datetime — 수정일시

inquiry_chatting_group_hist

  • id — bigint — PK' primary ke
  • org_id — bigint — NOT NULL — inquiry_chatting_group.id
  • venue_id — bigint — NOT NULL — 지점(venue.id)
  • category — varchar(64) — NOT NULL — 구분(채팅/서비스 신청)
  • title — varchar(256) — NOT NULL — 제목
  • status — int — NOT NULL — 대화 상태(시작/진행/완료)
  • client_id — bigint — 생성자(cleanier_user.id)
  • manager_id — bigint — 생성자(user.id)
  • created_at — datetime — NOT NULL — 생성일시

inquiry_chatting_message

  • id — bigint — PK' primary ke
  • group_id — bigint — NOT NULL — inquiry_chatting_group.id
  • message — text — NOT NULL — 대화 내용
  • is_read — tinyint(1) — NOT NULL — 읽음 여부
  • is_modified — tinyint(1) — NOT NULL — 변경 여부
  • client_id — bigint — 작성자(cleanier_user.id)
  • manager_id — bigint — 작성자(user.id)
  • created_at — datetime — NOT NULL — 생성일시
  • updated_at — datetime — 수정일시

inquiry_chatting_message_hist

  • id — bigint — PK' primary ke
  • org_id — bigint — NOT NULL — inquiry_chatting_message.id
  • group_id — bigint — NOT NULL — inquiry_chatting_group.id
  • message — text — NOT NULL — 대화 내용
  • client_id — bigint — 작성자(cleanier_user.id)
  • manager_id — bigint — 작성자(user.id)
  • created_at — datetime — NOT NULL — 생성일시

meta_field

  • id — bigint — PK' primary ke
  • type — varchar(64) — NOT NULL — TEXT, NUMBER, FILE, DATE, CHECKBOX, SELECT
  • code — varchar(64) — NOT NULL — 내부 구분용 ID
  • title — varchar(128) — NOT NULL — 화면 표시명
  • description — varchar(512) — 설명
  • required — tinyint(1) — NOT NULL — 필수 여부
  • deleted — tinyint(1) — NOT NULL — 삭제 여부

meta_field_option

  • id — bigint — PK' primary ke
  • title — varchar(128) — NOT NULL — 화면 표시명
  • description — varchar(512) — 설명
  • code — varchar(64) — NOT NULL — 저장될 값
  • field_id — bigint — NOT NULL — meta_field.id
  • remarks_field_id — bigint — 추가 필드(meta_field.id)

meta_service

  • id — bigint — PK' primary ke
  • title — varchar(128) — NOT NULL — 화면 표시명
  • description — varchar(512) — 설명(tool tip)
  • image_id — bigint — NOT NULL — file.id
  • active — tinyint(1) — NOT NULL — 활성화 여부

operator

  • id — bigint
  • created_at — datetime(6) — NOT NULL
  • updated_at — datetime(6)
  • name — varchar(255) — NOT NULL

operator_representative_assignment

  • id — bigint
  • created_at — datetime(6) — NOT NULL
  • updated_at — datetime(6)
  • client_id — bigint — NOT NULL
  • user_id — bigint — NOT NULL

partners

  • id — bigint
  • created_at — datetime(6) — NOT NULL
  • updated_at — datetime(6)
  • active — bit — NOT NULL
  • address — varchar(255) — NOT NULL
  • business_category — varchar(255) — NOT NULL
  • company_registration_number — varchar(255) — NOT NULL
  • memo — longtext
  • name — varchar(255) — NOT NULL
  • number — varchar(255) — NOT NULL
  • account_holder — varchar(255)
  • account_number — varchar(255)
  • bank — varchar(255)
  • representative_person_birthdate — date
  • representative_person_name — varchar(255) — NOT NULL
  • representative_person_number — varchar(255)
  • operator_id — bigint
  • bank_book_id — bigint
  • profile_image_id — bigint
  • code — varchar(12) — NOT NULL
  • email — varchar(255)
  • representative_person_gender — bigint — NOT NULL

partners_responsible_manager

  • id — bigint
  • created_at — datetime(6) — NOT NULL
  • updated_at — datetime(6)
  • partners_id — bigint — NOT NULL
  • user_id — bigint — NOT NULL

promotion_inquiry

  • id — bigint
  • created_at — datetime(6) — NOT NULL
  • updated_at — datetime(6)
  • address — varchar(255)
  • air_conditioner_count — bigint
  • date — varchar(255)
  • device — varchar(255) — NOT NULL
  • email — varchar(255) — NOT NULL
  • heater_count — bigint
  • keywords — varchar(255)
  • memo — varchar(1024)
  • name — varchar(255) — NOT NULL
  • phone — varchar(255) — NOT NULL
  • promotion_id — bigint — NOT NULL
  • promotion_name — varchar(255) — NOT NULL
  • provision_agreed — bit — NOT NULL
  • referrer — varchar(255)
  • sub_address — varchar(255)
  • area_id — bigint
  • area_name — varchar(255)
  • company_name — varchar(255)

runtime_constant

  • id — bigint
  • created_at — datetime(6) — NOT NULL
  • updated_at — datetime(6)
  • key_string — varchar(255) — NOT NULL
  • value_string — longtext — NOT NULL

service_preset

  • id — bigint
  • created_at — datetime(6) — NOT NULL
  • updated_at — datetime(6)
  • name — varchar(255) — NOT NULL

space_category

  • id — bigint
  • created_at — datetime(6) — NOT NULL
  • updated_at — datetime(6)
  • is_deleted — bit — NOT NULL
  • name — varchar(255) — NOT NULL
  • operator_id — bigint

space_category_preset

  • id — bigint
  • is_deleted — bit — NOT NULL
  • name — varchar(255) — NOT NULL
  • operator_id — bigint — NOT NULL

space_category_preset_assignment

  • id — bigint
  • space_category_id — bigint — NOT NULL
  • space_category_preset_id — bigint — NOT NULL

user

  • id — bigint
  • created_at — datetime(6) — NOT NULL
  • updated_at — datetime(6)
  • identifier — varchar(255) — NOT NULL
  • password — varchar(255) — NOT NULL
  • client_id — bigint
  • operator_id — bigint
  • user_contract_information_id — bigint
  • user_personal_information_id — bigint
  • user_role_id — bigint — NOT NULL
  • partners_id — bigint

user_contract_information

  • id — bigint
  • created_at — datetime(6) — NOT NULL
  • updated_at — datetime(6)
  • contract_begin — date
  • contract_end — date
  • contract_type — bigint — NOT NULL
  • pay — bigint
  • payment_bank_account — varchar(255)
  • payment_bank_holder — varchar(255)
  • payment_bank_name — varchar(255)
  • work_hour_begin — time
  • work_hour_end — time
  • contract_id — bigint
  • pay_type — bigint — NOT NULL

user_inquiry

  • id — bigint
  • created_at — datetime(6) — NOT NULL
  • updated_at — datetime(6)
  • email — varchar(100) — NOT NULL
  • name — varchar(30) — NOT NULL
  • phone — varchar(30) — NOT NULL
  • memo — longtext
  • user_id — bigint — NOT NULL

user_issued_token

  • id — bigint
  • created_at — datetime(6) — NOT NULL
  • updated_at — datetime(6)
  • access_token — varchar(255)
  • device — varchar(255)
  • fcm_token — varchar(255)
  • refresh_token — varchar(255)
  • user_id — bigint — NOT NULL
  • access_expired_time — datetime
  • refresh_expired_time — datetime

user_personal_information

  • id — bigint
  • created_at — datetime(6) — NOT NULL
  • updated_at — datetime(6)
  • birthdate — date
  • duplication_information — varchar(255)
  • email — varchar(255)
  • gender — bigint
  • is_mobile_app_registered — bit
  • memo — varchar(255)
  • name — varchar(255) — NOT NULL
  • phone — varchar(255) — NOT NULL
  • position — varchar(255)
  • recommender — varchar(255)
  • resident_registration_number — varchar(255)
  • profile_image — bigint

user_role

  • id — bigint
  • created_at — datetime(6) — NOT NULL
  • updated_at — datetime(6)
  • code — varchar(255) — NOT NULL
  • name — varchar(255) — NOT NULL

venue

  • id — bigint
  • created_at — datetime(6) — NOT NULL
  • updated_at — datetime(6)
  • business_category — varchar(255)
  • ceo_name — varchar(255) — NOT NULL
  • company_registration_number — varchar(255) — NOT NULL
  • contract_begin — date
  • contract_end — date
  • inherits_client — bit — NOT NULL
  • is_deleted — bit — NOT NULL
  • name — varchar(255) — NOT NULL
  • building_id — bigint — NOT NULL
  • client_id — bigint — NOT NULL
  • operator_id — bigint — NOT NULL
  • space_category_preset_id — bigint — NOT NULL
  • is_active — bit — NOT NULL