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