knockdock
Tables (38)
FILTER (filter_item)
- id — BIGSERIAL
- type — TEXT — NOT NULL
- code — TEXT — NOT NULL
- label — TEXT — NOT NULL
- coord — JSONB
- count — INTEGER
- zoom — INTEGER
- created_at — TIMESTAMPTZ
- updated_at — TIMESTAMPTZ
NAME (name_item)
- id — BIGSERIAL
- type — TEXT — NOT NULL
- code — TEXT — NOT NULL
- label — TEXT — NOT NULL
- lat — NUMERIC(9,7)
- lng — NUMERIC(10,7)
- count — INTEGER
- zoom — INTEGER
- created_at — TIMESTAMPTZ
- updated_at — TIMESTAMPTZ
PLACE (place)
- ID (place_id) — BIGINT — NOT NULL
- NAME (name) — TEXT — NOT NULL
- TEL (tel) — TEXT
- ADDRESS (address) — TEXT
- ROAD_ADDRESS (road_address) — TEXT
- LAT (lat) — NUMERIC(9,7)
- LNG (lng) — NUMERIC(10,7)
- BUSINESS_HOURS (운영시간) — varchar(60)
- DISTANCE_KM (distance_km) — DOUBLE
- LOWEST_PRICE (lowest_price) — INTEGER
- THUMBNAIL_S3_KEY (thumbnail_s3_key) — TEXT
- INTRODUCTION (introduction) — TEXT
- CREATED_AT (created_at) — TIMESTAMPTZ
- UPDATED_AT (updated_at) — TIMESTAMPTZ
- MENU_IMAGE_S3_KEYS (메뉴 이미지 key) — varchar(60)
- MENUS (메뉴) — varchar(60)
- REVIEW_COUNTS (리뷰 수) — varchar(60)
- LINKS (url) — varchar(60)
- CATEGORIES (카테고리) — varchar(60)
- SERVICES (서비스) — varchar(255)
- PRICEIMAGES (가격표이미지) — varchar(255)
- AVG_PRICE_PER_TIME (시간당 평균 금액) — varchar(255)
REGION
- id — BIGSERIAL
- type — TEXT — NOT NULL
- code — TEXT — NOT NULL
- label — TEXT — NOT NULL
- lat — NUMERIC(9,7)
- lng — NUMERIC(10,7)
- count — INTEGER
- zoom — INTEGER
- created_at — TIMESTAMPTZ
- updated_at — TIMESTAMPTZ
bookmark
- id — bigint — Primary key — NOT NULL
- created_at — datetime(6) — NOT NULL
- target_id — varchar(100) — NOT NULL
- user_id — bigint — Foreign key → user.id — NOT NULL
checklist_answer
- id — bigint — Primary key — NOT NULL
- value_boolean — bit(1)
- value_json — json
- value_number — decimal(38,2)
- value_string — varchar(1000)
- question_id — bigint — Foreign key → checklist_question.id — NOT NULL
- submission_id — bigint — Foreign key → checklist_submission.id — NOT NULL
checklist_question
- id — bigint — Primary key — NOT NULL
- code — varchar(150) — NOT NULL
- help_text — varchar(500)
- label — varchar(500) — NOT NULL
- order_index — int — NOT NULL
- required — bit(1) — NOT NULL
- type — enum('BOOLEAN','DATE','INTEGER','MULTI_SELECT','SELECT','TEXT','TRI_STATE') — NOT NULL
- validation_json — json
- section_id — bigint — Foreign key → checklist_section.id — NOT NULL
checklist_section
- id — bigint — Primary key — NOT NULL
- code — varchar(100) — NOT NULL
- order_index — int — NOT NULL
- title — varchar(200) — NOT NULL
- template_id — bigint — Foreign key → checklist_template.id — NOT NULL
checklist_submission
- id — bigint — Primary key — NOT NULL
- created_at — datetime(6) — NOT NULL
- target_id — bigint
- user_id — bigint
- template_id — bigint — Foreign key → checklist_template.id — NOT NULL
checklist_template
- id — bigint — Primary key — NOT NULL
- code — varchar(100) — NOT NULL
- created_at — datetime(6) — NOT NULL
- effective_from — datetime(6)
- effective_to — datetime(6)
- locale — varchar(10) — NOT NULL
- status — enum('ACTIVE','DRAFT','RETIRED') — NOT NULL
- title — varchar(200) — NOT NULL
- version — varchar(50) — NOT NULL
free_memo
- id — bigint — Primary key — NOT NULL
- content — text
- created_at — datetime(6)
- target_id — bigint
- user_id — bigint — Foreign key → user.id
free_memo_photo
- id — bigint — Primary key — NOT NULL
- content_type — varchar(255)
- original_filename — varchar(255)
- s3key — varchar(255)
- sha256 — varchar(255)
- size — bigint — NOT NULL
- memo_id — bigint — Foreign key → free_memo.id
kg_change_evidence
- id — bigint — Primary key — NOT NULL
- category — enum('ADDRESS','BUSINESS_CLOSED','HOURS','PHONE','PRICE') — NOT NULL
- content_type — varchar(255)
- created_at — datetime(6)
- height — int
- original_filename — varchar(255)
- s3_key — varchar(512) — NOT NULL
- sha256 — varchar(64)
- size_bytes — bigint — NOT NULL
- width — int
- report_id — bigint — Foreign key → kg_change_report.id — NOT NULL
kg_change_report
- id — bigint — Primary key — NOT NULL
- created_at — datetime(6)
- kindergarten_id — varchar(64) — NOT NULL
- requested_address — varchar(255)
- status — enum('APPROVED','NEW','REJECTED') — NOT NULL
- updated_at — datetime(6)
question_option
- id — bigint — Primary key — NOT NULL
- code — varchar(100) — NOT NULL
- label — varchar(200) — NOT NULL
- order_index — int — NOT NULL
- question_id — bigint — Foreign key → checklist_question.id — NOT NULL
social_user
- id — bigint — Primary key — NOT NULL
- created_at — datetime(6) — NOT NULL
- email — varchar(255) — NOT NULL
- is_linked — bit(1) — NOT NULL
- linked_at — datetime(6)
- name — varchar(255)
- picture — varchar(255)
- provider — enum('APPLE','GOOGLE','KAKAO') — NOT NULL
- provider_id — varchar(255) — NOT NULL
- user_id — varchar(255)
- status — tinyint — NOT NULL
social_user_link
- id — bigint — Primary key — NOT NULL
- created_at — datetime(6) — NOT NULL
- email — varchar(255) — NOT NULL
- linked_at — datetime(6)
- provider — enum('APPLE','GOOGLE','KAKAO') — NOT NULL
- provider_id — varchar(255) — NOT NULL
- status — enum('DISCONNECTED','LINKED','PENDING') — NOT NULL
- user_id — varchar(26)
tb_admin
- admin_id — bigint — Primary key — NOT NULL
- id — varchar(255) — NOT NULL
- name — varchar(255) — NOT NULL
- phone_number — varchar(255) — NOT NULL
- pwd — varchar(255) — NOT NULL
- registered_date — date
- registration_number — varchar(255)
- role — enum('APPROVAL_CANCEL','APPROVAL_DENIED','APPROVAL_PENDING','APPROVED','ROLE_ANONYMOUS','ROLE_MEMBER','ROLE_OWNER','ROLE_TEACHER','WITHDRAWN') — NOT NULL
- image_id_fk — bigint — Foreign key → tb_image.image_id
tb_agenda
- agenda_id — bigint — Primary key — NOT NULL
- created_at — datetime(6)
- created_by — varchar(255)
- modified_at — datetime(6)
- modified_by — varchar(255)
- agenda_note — text
- date — date
- poop — enum('HARD','HEALTHY','NOT_BROWN','WARNING','WATERY')
- poop_memo — text
- reserved_time — varchar(255)
- snack — text
- status — enum('COMPLETE','NOT_YET','WRITING')
- admin_id_fk — bigint — Foreign key → tb_admin.admin_id
- dog_id_fk — bigint — Foreign key → tb_dog.dog_id
tb_alarm
- alarm_id — bigint — Primary key — NOT NULL
- created_at — datetime(6)
- created_by — varchar(255)
- modified_at — datetime(6)
- modified_by — varchar(255)
- category — enum('ATTENDANCE','CARE','ETC','MANAGEMENT','MEMBER')
- size — int
tb_alarm_event
- alarm_event_id — bigint — Primary key — NOT NULL
- created_at — datetime(6)
- created_by — varchar(255)
- modified_at — datetime(6)
- modified_by — varchar(255)
- content_id — bigint
- content_type — enum('AGENDA_ARRIVED','AGENDA_NOT_YET_SENT','AGREEMENT_UPDATE','DOG_IMAGE','DOG_INFO_UPDATE','ENROLLMENT_APPROVED','ENROLLMENT_DENIED','IMAGE_NOT_YET_SENT','NEW_DOG','NEW_ENROLLMENT','NEW_TEACHER','PENDING_TICKET','TEACHER_DROP_OUT','TICKET_EXPIRED','TICKET_UPDATE')
- admin_id_fk — bigint — Foreign key → tb_admin.admin_id
- alarm_id_fk — bigint — Foreign key → tb_alarm.alarm_id
- dog_id_fk — bigint — Foreign key → tb_dog.dog_id
- is_read — bit(1)
- read_at — datetime(6)
- content — varchar(255)
tb_attendance
- attendance_id — bigint — Primary key — NOT NULL
- created_at — datetime(6)
- created_by — varchar(255)
- modified_at — datetime(6)
- modified_by — varchar(255)
- date — date
- date_time — datetime(6)
- status — enum('APPROVAL_CANCEL','APPROVAL_DENIED','APPROVAL_PENDING','ATTENDED','DIS_CONNECTED','DROP_OUT','ENROLLED','NOT_ATTENDED') — NOT NULL
- admin_id_fk — bigint — Foreign key → tb_admin.admin_id
- dog_id_fk — bigint — Foreign key → tb_dog.dog_id
tb_breed
- breed_id — bigint — Primary key — NOT NULL
- name — varchar(255)
- type — varchar(255)
- unit — varchar(255)
tb_dog
- dog_id — bigint — Primary key — NOT NULL
- created_at — datetime(6)
- created_by — varchar(255)
- modified_at — datetime(6)
- modified_by — varchar(255)
- agreements — json
- allergy_disease — text
- birth_date — date
- dog_memo_by_admin — text
- gender — enum('FEMALE','MALE')
- name — varchar(255) — NOT NULL
- neutralization — enum('NEUTERED','NOT_NEUTERED')
- pick_drop_memo — text
- pick_drop_request — enum('NOT_REQUEST','NOT_RUNNING','ONE_WAY','REQUEST','ROUND','RUNNING')
- pick_drop_type — enum('NOT_REQUEST','NOT_RUNNING','ONE_WAY','REQUEST','ROUND','RUNNING')
- registered_date — date
- size — enum('BIG','MEDIUM','SMALL')
- vaccination — enum('NOT_VACCINATED','VACCINATED')
- member_id_fk — bigint — Foreign key → tb_member.member_id
- school_id_fk — bigint — Foreign key → tb_school.school_id
- ticket_id_fk — bigint
- breed — varchar(255)
- profile_image — varchar(255)
- enrollmentform_id_fk — bigint
- breed_id_fk — bigint
- image_id_fk — bigint
tb_enrollmentform
- enrollment_form_id — bigint — Primary key — NOT NULL
- created_at — datetime(6)
- created_by — varchar(255)
- modified_at — datetime(6)
- modified_by — varchar(255)
- address — varchar(255)
- address_detail — varchar(255)
- agreements — json
- allergy_disease — text
- attendance_days — varchar(255)
- breed_id_fk — bigint
- dog_birth_date — date
- dog_gender — enum('FEMALE','MALE')
- dog_name — varchar(255)
- dog_size — enum('BIG','MEDIUM','SMALL')
- drop_out_date — date
- emergency_phone_number — varchar(255)
- member_gender — enum('FEMALE','MALE')
- member_id_fk — bigint
- member_name — varchar(255)
- monthly_ticket_number — int — NOT NULL
- neutralization — enum('NEUTERED','NOT_NEUTERED')
- new_breed — varchar(255)
- phone_number — varchar(255)
- pick_drop_memo — text
- pick_drop_request — enum('NOT_REQUEST','NOT_RUNNING','ONE_WAY','REQUEST','ROUND','RUNNING')
- pick_drop_type — enum('NOT_REQUEST','NOT_RUNNING','ONE_WAY','REQUEST','ROUND','RUNNING')
- registered_date — date
- round_ticket_number — int — NOT NULL
- status — enum('APPROVAL_CANCEL','APPROVAL_DENIED','APPROVAL_PENDING','ATTENDED','DIS_CONNECTED','DROP_OUT','ENROLLED','NOT_ATTENDED')
- ticket_type — enum('MONTHLY','ROUND')
- vaccination — enum('NOT_VACCINATED','VACCINATED')
- vaccination_image — json
- dog_id_fk — bigint — Foreign key → tb_dog.dog_id
- school_form_id_fk — bigint — Foreign key → tb_school_form.school_form_id
tb_fcm
- fcm_id — bigint — Primary key — NOT NULL
- fcm_token — varchar(255) — NOT NULL
- member_id_fk — bigint — Foreign key → tb_member.member_id
- admin_id_fk — bigint — Foreign key → tb_admin.admin_id
tb_image
- image_id — bigint — Primary key — NOT NULL
- created_at — datetime(6)
- created_by — varchar(255)
- modified_at — datetime(6)
- modified_by — varchar(255)
- comment — text
- groud_id — bigint
- image_type — enum('IMAGE','PROFILE','VACCINATION','VIDEO_THUMBNAIL')
- size — int — NOT NULL
- uri — varchar(255)
- dog_id_fk — bigint — Foreign key → tb_dog.dog_id
tb_link_firebase_auth_member
- id — bigint — Primary key — NOT NULL
- uid — text — NOT NULL
- member_id_fk — bigint — Foreign key → tb_member.member_id
tb_link_school_admin
- link_school_admin_id — bigint — Primary key — NOT NULL
- admin_registered_date — date
- admin_resigned_date — date
- admin_id_fk — bigint — Foreign key → tb_admin.admin_id
- school_id_fk — bigint — Foreign key → tb_school.school_id
tb_member
- member_id — bigint — Primary key — NOT NULL
- address — varchar(255)
- address_detail — varchar(255)
- email — varchar(255)
- emergency_phone_number — varchar(255)
- gender — enum('FEMALE','MALE')
- name — varchar(10)
- nick_name — varchar(255)
- phone_number — varchar(255)
- relation — enum('BROTHER','FATHER','FRIEND','MOTHER','SISTER')
- role — enum('APPROVAL_CANCEL','APPROVAL_DENIED','APPROVAL_PENDING','APPROVED','ROLE_ANONYMOUS','ROLE_MEMBER','ROLE_OWNER','ROLE_TEACHER','WITHDRAWN') — NOT NULL
- social_token — varchar(255)
- image_id_fk — bigint — Foreign key → tb_image.image_id
tb_push
- id — bigint — Primary key — NOT NULL
- accepts_activity — bit(1) — NOT NULL
- accepts_service — bit(1) — NOT NULL
- admin_id_fk — bigint — Foreign key → tb_admin.admin_id
- accepts_attendance — bit(1) — NOT NULL
- accepts_care — bit(1) — NOT NULL
- accepts_school — bit(1) — NOT NULL
- member_id_fk — bigint — Foreign key → tb_member.member_id
- dog_id_fk — bigint — Foreign key → tb_dog.dog_id
tb_refresh_token
- id — bigint — Primary key — NOT NULL
- refresh_token — text — NOT NULL
- identifier — varchar(255) — NOT NULL
tb_school
- school_id — bigint — Primary key — NOT NULL
- address — varchar(255) — NOT NULL
- name — varchar(255) — NOT NULL
- phone_number — varchar(255) — NOT NULL
- address_detail — varchar(255)
- created_at — datetime(6)
- created_by — varchar(255)
- modified_at — datetime(6)
- modified_by — varchar(255)
tb_school_form
- school_form_id — bigint — Primary key — NOT NULL
- created_at — datetime(6)
- created_by — varchar(255)
- modified_at — datetime(6)
- modified_by — varchar(255)
- abandonment_info — text
- accident_info — text
- form_name — varchar(255) — NOT NULL
- limits_info — text
- modified_info_list — varchar(255)
- monthly_ticket_number — varchar(255)
- open_days — varchar(255)
- pick_drop_info — text
- pick_drop_notice — text
- pick_drop_state — enum('NOT_REQUEST','NOT_RUNNING','ONE_WAY','REQUEST','ROUND','RUNNING')
- price_info — text
- required_item_list — varchar(255)
- round_ticket_number — varchar(255)
- ticket_info — text
- ticket_type — varchar(255)
- school_id_fk — bigint — Foreign key → tb_school.school_id
- is_deleted — bit(1) — NOT NULL
tb_ticket
- ticket_id — bigint — Primary key — NOT NULL
- created_at — datetime(6)
- created_by — varchar(255)
- modified_at — datetime(6)
- modified_by — varchar(255)
- all_rounds — int — NOT NULL
- attendance_days — varchar(255)
- current_rounds — int — NOT NULL
- dog_id_fk — bigint
- expiration_date — date
- monthly_ticket_number — int — NOT NULL
- start_date — date
- ticket_type — enum('MONTHLY','ROUND')
tb_video
- video_id — bigint — Primary key — NOT NULL
- created_at — datetime(6)
- created_by — varchar(255)
- modified_at — datetime(6)
- modified_by — varchar(255)
- original_file_name — varchar(255)
- video_url — varchar(255)
- dog_id_fk — bigint — Foreign key → tb_dog.dog_id
- converted_file_name — varchar(255)
- video_thumbnail_url — varchar(255)
user
- id — bigint — Primary key — NOT NULL
- created_at — datetime(6) — NOT NULL
- nickname — varchar(100) — NOT NULL
- profile_image — varchar(500)
- status — enum('ACTIVE','WITHDRAWN') — NOT NULL
- updated_at — datetime(6) — NOT NULL
- user_id — varchar(26)
- removed_at — datetime(6)
user_address
- id — bigint — Primary key — NOT NULL
- alias — varchar(20)
- detail_address — varchar(200) — NOT NULL
- jibun_address — varchar(200) — NOT NULL
- lat — decimal(38,2) — NOT NULL
- lng — decimal(38,2) — NOT NULL
- road_address — varchar(200) — NOT NULL
- type — enum('HOME','OTHER','WORK') — NOT NULL
- user_id — bigint — Foreign key → user.id — NOT NULL