Hometalkonepass
Tables (40)
alarm_notification
- id — bigint — Primary key — NOT NULL
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
- category_alarm — varchar(50) — NOT NULL
- deleted_at — datetime(6)
- is_read — bit(1)
- message — varchar(500) — NOT NULL
- module_name — varchar(50) — NOT NULL
- user_id — bigint — Foreign key → users.id — NOT NULL
alarm_notification_to_billing
- id — bigint — Primary key — NOT NULL
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
- billing_items — json
- billing_month — varchar(50) — NOT NULL
- category_alarm — varchar(50) — NOT NULL
- deleted_at — datetime(6)
- due_date — date — NOT NULL
- is_read — bit(1)
- message — varchar(500) — NOT NULL
- module_name — varchar(50) — NOT NULL
- status — enum('PAID','UNPAID')
- total_amount — decimal(12,0) — NOT NULL
- user_id — bigint — Foreign key → users.id — NOT NULL
alarm_notification_to_parking
- id — bigint — Primary key — NOT NULL
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
- category_alarm — varchar(50) — NOT NULL
- deleted_at — datetime(6)
- is_read — bit(1)
- message — varchar(500) — NOT NULL
- module_name — varchar(50) — NOT NULL
- vehicle_number — varchar(100) — NOT NULL
- user_id — bigint — Foreign key → users.id — NOT NULL
attachment
- id — bigint — Primary key — NOT NULL
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
- file_name — varchar(255)
- file_path — varchar(255)
- file_size — bigint — NOT NULL
- notice_id — bigint — Foreign key → notice.id
billing
- id — bigint — Primary key — NOT NULL
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
- billing_month — varchar(7) — NOT NULL
- due_date — date — NOT NULL
- last_upload_type — varchar(10)
- status — enum('PAID','UNPAID') — NOT NULL
- total_amount — decimal(12,0) — NOT NULL
- household_id — bigint — Foreign key → household.id — NOT NULL
billing_detail
- id — bigint — Primary key — NOT NULL
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
- item_amount — decimal(12,0) — NOT NULL
- item_name — varchar(100) — NOT NULL
- sort_order — int — NOT NULL
- billing_id — bigint — Foreign key → billing.id — NOT NULL
billing_log
- id — bigint — Primary key — NOT NULL
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
- action_type — enum('STATUS_CHANGE','UPLOAD') — NOT NULL
- user_id — bigint
- billing_id — bigint — Foreign key → billing.id
billing_to_dash_board_info
- id — bigint — Primary key — NOT NULL
- billing_month — varchar(7) — NOT NULL
- due_date — date — NOT NULL
- item_amount — decimal(12,0) — NOT NULL
- item_name — varchar(100) — NOT NULL
- status — enum('PAID','UNPAID') — NOT NULL
- total_amount — decimal(12,0) — NOT NULL
- user_id — bigint
boards
- id — bigint — Primary key — NOT NULL
- code — varchar(255) — NOT NULL
- name — varchar(255) — NOT NULL
- is_system — bit(1)
categories
- id — bigint — Primary key — NOT NULL
- code — varchar(255) — NOT NULL
- color — varchar(255)
- name — varchar(255) — NOT NULL
- is_system — bit(1)
- board_id — bigint — Foreign key → boards.id — NOT NULL
- bg_color — varchar(255)
- text_color — varchar(255)
comments
- id — bigint — Primary key — NOT NULL
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
- deleted_at — datetime(6)
- content — varchar(255) — NOT NULL
- post_id — bigint — Foreign key → posts.id — NOT NULL
- user_id — bigint — Foreign key → users.id — NOT NULL
household
- id — bigint — Primary key — NOT NULL
- building_name — varchar(100) — NOT NULL
- dong — varchar(20) — NOT NULL
- ho — varchar(20) — NOT NULL
- post_num — varchar(255) — NOT NULL
kjh_complaint
- id — bigint — Primary key — NOT NULL
- answer — varchar(255)
- category — varchar(255)
- content — text — NOT NULL
- created_at — datetime(6)
- status — varchar(255)
- title — varchar(255) — NOT NULL
- updated_at — datetime(6)
- view_count — int — NOT NULL
- user_id — bigint — Foreign key → users.id
- secret — bit(1)
- is_secret — bit(1) — NOT NULL
kjh_complaint_answer
- id — bigint — Primary key — NOT NULL
- content — text — NOT NULL
- created_at — datetime(6)
- writer_name — varchar(255)
- complaint_id — bigint — Foreign key → kjh_complaint.id
kjh_complaint_attachment
- id — bigint — Primary key — NOT NULL
- file_path — varchar(255)
- origin_file_name — varchar(255)
- stored_file_name — varchar(255)
- complaint_id — bigint — Foreign key → kjh_complaint.id
kjh_facility
- id — bigint — Primary key — NOT NULL
- icon_type — varchar(255)
- image_path — varchar(255)
- location — varchar(255)
- name — varchar(255)
- close_time — time
- open_time — time
kjh_inquiry
- id — bigint — Primary key — NOT NULL
- answer — varchar(255)
- category — varchar(255)
- content — varchar(255)
- created_at — datetime(6)
- status — varchar(255)
- title — varchar(255)
- user_id — bigint — Foreign key → users.id
- is_secret — bit(1)
kjh_inquiry_attachment
- id — bigint — Primary key — NOT NULL
- file_path — varchar(255)
- origin_file_name — varchar(255)
- stored_file_name — varchar(255)
- inquiry_id — bigint — Foreign key → kjh_inquiry.id
kjh_reservation
- id — bigint — Primary key — NOT NULL
- end_time — datetime(6)
- start_time — datetime(6)
- status — enum('CANCELED','COMPLETED','CONFIRMED','PENDING')
- facility_id — bigint — Foreign key → kjh_facility.id
- user_id — bigint — Foreign key → users.id
local_account
- user_id — bigint — Foreign key → users.id — NOT NULL
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
- email_verified — bit(1) — NOT NULL
- email_verify_token — varchar(255)
- login_id — varchar(100) — NOT NULL
- password_hash — varchar(255) — NOT NULL
notice
- id — bigint — Primary key — NOT NULL
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
- badge — varchar(20)
- content — text — NOT NULL
- is_pinned — bit(1)
- status — varchar(20)
- title — varchar(100) — NOT NULL
- view_count — int — NOT NULL
- user_id — bigint — Foreign key → users.id
notice_to_dash_board_info
- id — bigint — Primary key — NOT NULL
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
- title — varchar(100) — NOT NULL
- user_id — bigint — Foreign key → users.id
notification
- id — bigint — Primary key — NOT NULL
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
- expired_at — datetime(6)
- link — varchar(255)
- message — varchar(255)
- reference_id — bigint
- target_role — enum('ADMIN','RESIDENT')
- title — varchar(255)
- type — varchar(40)
- user_id — bigint
notification_read
- id — bigint — Primary key — NOT NULL
- read_at — datetime(6) — NOT NULL
- user_id — bigint — NOT NULL
- notification_id — bigint — Foreign key → notification.id — NOT NULL
parking_logs
- parking_id — bigint — Primary key — NOT NULL
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
- deleted_at — datetime(6)
- applied_minutes — int
- entry_time — datetime(6) — NOT NULL
- entry_type — enum('MANUAL','NORMAL','RESERVATION') — NOT NULL
- exit_time — datetime(6)
- status — enum('EXITED','OVERSTAY','PARKED') — NOT NULL
- total_minutes — int
- vehicle_number — varchar(20) — NOT NULL
- household_id — bigint — Foreign key → household.id
- reservation_id — bigint — Foreign key → visit_reservations.reservation_id
- staff_id — bigint — Foreign key → users.id
- vehicle_id — bigint — Foreign key → vehicles.vehicle_id
parking_tickets
- ticket_id — bigint — Primary key — NOT NULL
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
- issue_month — int — NOT NULL
- issue_year — int — NOT NULL
- issued_date — date — NOT NULL
- total_count — int — NOT NULL
- type — enum('DAY','HOUR') — NOT NULL
- used_count — int — NOT NULL
- version — bigint
- household_id — bigint — Foreign key → household.id — NOT NULL
parking_to_dash_board_info
- id — bigint — Primary key — NOT NULL
- total_count — int — NOT NULL
- type — enum('DAY','HOUR') — NOT NULL
- used_count — int — NOT NULL
- user_id — bigint — Foreign key → users.id — NOT NULL
persistent_logins
- series — varchar(64) — Primary key — NOT NULL
- last_used — datetime(6) — NOT NULL
- token — varchar(64) — NOT NULL
- username — varchar(64) — NOT NULL
post_images
- id — bigint — Primary key — NOT NULL
- path — varchar(255) — NOT NULL
- post_id — bigint — Foreign key → posts.id — NOT NULL
post_tags
- id — bigint — Primary key — NOT NULL
- post_id — bigint — Foreign key → posts.id — NOT NULL
- tag_id — bigint — Foreign key → tags.id — NOT NULL
posts
- id — bigint — Primary key — NOT NULL
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
- deleted_at — datetime(6)
- comment_count — int — NOT NULL
- content — text — NOT NULL
- has_image — bit(1) — NOT NULL
- market_status — enum('COMPLETED','NONE','RESERVED','SHARED')
- pinned — bit(1) — NOT NULL
- post_status — enum('ACTIVE','DELETED','DRAFT','HIDDEN') — NOT NULL
- title — varchar(100) — NOT NULL
- view_count — int — NOT NULL
- board_id — bigint — Foreign key → boards.id — NOT NULL
- category_id — bigint — Foreign key → categories.id — NOT NULL
- user_id — bigint — Foreign key → users.id — NOT NULL
read_log
- id — bigint — Primary key — NOT NULL
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
- notice_id — bigint — Foreign key → notice.id — NOT NULL
- user_id — bigint — Foreign key → users.id — NOT NULL
schedule
- id — bigint — Primary key — NOT NULL
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
- badge — varchar(20)
- end_at — datetime(6)
- info — varchar(255)
- location — varchar(255)
- reference_url — varchar(255)
- repeat_end_at — datetime(6)
- repeat_group_id — bigint
- repeat_type — varchar(20)
- start_at — datetime(6) — NOT NULL
- title — varchar(100) — NOT NULL
- notice_id — bigint — Foreign key → notice.id
- user_id — bigint — Foreign key → users.id — NOT NULL
social_account
- id — bigint — Primary key — NOT NULL
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
- platform — enum('GOOGLE','KAKAO','NAVER') — NOT NULL
- platform_id — varchar(100) — NOT NULL
- raw_token_data — json
- social_access_token — text
- social_refresh_token — text
- social_token_expires_at — datetime(6)
- user_id — bigint — Foreign key → users.id — NOT NULL
tags
- id — bigint — Primary key — NOT NULL
- name — varchar(255) — NOT NULL
ticket_usage
- usage_id — bigint — Primary key — NOT NULL
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
- used_count — int — NOT NULL
- used_minutes — int — NOT NULL
- parking_id — bigint — Foreign key → parking_logs.parking_id — NOT NULL
- ticket_id — bigint — Foreign key → parking_tickets.ticket_id — NOT NULL
users
- id — bigint — Primary key — NOT NULL
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
- deleted_at — datetime(6)
- email — varchar(100) — NOT NULL
- name — varchar(50) — NOT NULL
- nickname — varchar(30)
- phone_number — varchar(20)
- role — enum('ADMIN','MEMBER','RESIDENT','STAFF') — NOT NULL
- status — enum('APPROVED','PENDING','REJECTED') — NOT NULL
- household_id — bigint — Foreign key → household.id
- approval_notice_shown — bit(1) — NOT NULL
vehicle_approvals
- approval_id — bigint — Primary key — NOT NULL
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
- document_path — text — NOT NULL
- processed_at — datetime(6)
- reject_reason — varchar(255)
- status — enum('APPROVED','PENDING','REJECTED') — NOT NULL
- admin_id — bigint — Foreign key → users.id
- vehicle_id — bigint — Foreign key → vehicles.vehicle_id — NOT NULL
vehicles
- vehicle_id — bigint — Primary key — NOT NULL
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
- deleted_at — datetime(6)
- model — varchar(50)
- status — enum('APPROVED','PENDING','REJECTED') — NOT NULL
- vehicle_number — varchar(20) — NOT NULL
- vehicle_type — varchar(20)
- household_id — bigint — Foreign key → household.id
- user_id — bigint — Foreign key → users.id — NOT NULL
visit_reservations
- reservation_id — bigint — Primary key — NOT NULL
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
- deleted_at — datetime(6)
- purpose — varchar(100) — NOT NULL
- reserved_at — datetime(6) — NOT NULL
- status — enum('CANCELLED','ENTERED','PENDING_CONFIRM','RESERVED') — NOT NULL
- vehicle_number — varchar(20) — NOT NULL
- household_id — bigint — Foreign key → household.id