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