infraK
Tables (10)
Untitled (user_auth)
- Key (id) — Primary key — NOT NULL
- Field (auth)
- Field (auth_order)
- Field (create_at)
- Field (create_ip)
- Field (update_at)
Untitled (board_type)
- Key (id) — Primary key — NOT NULL
- Field (type_name)
- Field (enabled)
- Field (create_at)
- Field (update_at)
- Field (create_ip)
- Field (update_ip)
Untitled (board)
- Key (id) — Primary key — NOT NULL
- Key (type_id) — Foreign key → Untitled.Key — NOT NULL
- Key — Foreign key → Untitled.Key — NOT NULL
- Field (user_id)
- Field (title)
- Field (content)
- Field (file_index)
- Field (file_count)
- Field (create_at)
- Field (create_ip)
- Field (update_at)
- Field (update_ip)
- Field (delete_at)
- Field (delete_ip)
Untitled (board_tag)
- Key (id) — Primary key — NOT NULL
- Field (tag_name)
- Field (tag_order)
- Field (create_at)
- Field (update_at)
- Field (create_ip)
- Field (update_ip)
Untitled (agreement_item)
- Key (id) — Primary key — NOT NULL
- Field (title)
- Field (content)
- Field (required)
- Field (enabled)
- Field (create_at)
- Field (create_ip)
- Field (update_at)
- Field (update_ip)
Untitled (config)
- Key (id) — Primary key — NOT NULL
- Field (travel_cost)
- Field (travel_cost_holiday)
- Field (apply_travel_cost)
- Field (create_at)
- Field (create_ip)
Untitled (upload_files)
- Key (id) — Primary key — NOT NULL
- Field (file_index)
- Field (origin_name)
- Field (extension)
- Field (save_path)
- Field (save_name)
- Field (url)
- Field (mime_type)
- Field (file_size)
- Field (create_at)
- Field (create_ip)
- Field (delete_at)
- Field (delete_ip)
Untitled (service)
- Key (id) — Primary key — NOT NULL
- Field (category_depth_1)
- Field (category_depth_2)
- Field (category_depth_3)
- Field (title)
- Field (content)
- Field (zipcode)
- Field (address)
- Field (address_detail)
- Field (user_id)
- Field2 (user_name)
- Field (user_phone)
- Field (user_email)
- Field (company_name)
- Field (team_name)
- Field (manager_id)
- Field (service_date_1)
- Field (service_date_1_at)
- Field (service_date_2)
- Field (service_date_2_at)
- Field (service_date_3)
- Field (service_date_3_at)
- Field (service_date)
- Field (service_date_at)
- Field (complate_date)
- Field (travel_cost)
- Field (travel_cost_free)
- Field (cost)
- Field (status)
- Field2 (upload_file_index)
- Field2 (upload_file_count)
- Field2 (estimate_file_index)
- Field2 (estimate_file_count)
- Field2 (report_file_index)
- Field2 (report_file_count)
- Field2 (create_at)
- Field2 (create_ip)
- Field2 (update_at)
- Field2 (update_ip)
Untitled (service_category)
- Key (id) — Primary key — NOT NULL
- Field (parent_id)
- Field (type)
- Field (depth)
- Field (category_name)
- Field (enabled)
- Field (apply_cost)
- Field (create_at)
- Field (create_ip)
- Field (update_at)
- Field (update_ip)
user (회원)
- id — Primary key — NOT NULL
- Key (auth) — Foreign key → Untitled.Key — NOT NULL
- auth_id
- auth_password
- Field (auth_salt)
- Field4 (name)
- Field (email)
- Field (phone)
- Field (zipcode)
- Field (address)
- Field (address_detail)
- Field (company_name)
- Field (ceo_name)
- Field (ceo_email)
- Field (licenses_number)
- Field (business_number)
- Field (description)
- Field (create_at)
- Field (create_ip)
- Field (update_at)
- Field (update_ip)
- Field (delete_at)
- Field (delete_ip)