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