ㅁㄴㅇ
Tables (43)
smi_account
- account_idx — int(11) — Primary key — NOT NULL
- id — varchar(300) — NOT NULL — UNIQUE
- password — varchar(500) — NOT NULL
- salt — text — NOT NULL
- is_agree_account_conditions — tinyint(4) — NOT NULL
- name — varchar(100) — NOT NULL
- email — varchar(100) — NOT NULL
- email_verification — tinyint(1) — NOT NULL
- phone_number — varchar(100)
- phone_verification — tinyint(4)
- address — varchar(128)
- detail_address — varchar(128)
- zip — varchar(50)
- is_agree_gather — tinyint(4) — NOT NULL
- marketing_notification — tinyint(4) — NOT NULL
- sms_notification — tinyint(4) — NOT NULL
- pc_notification — tinyint(4) — NOT NULL
- mail_notification — tinyint(4) — NOT NULL
- chat_notification — tinyint(4) — NOT NULL
- estimate_notification — tinyint(4) — NOT NULL
- account_files — longtext
- account_image — longtext
- is_enterprise — tinyint(4) — NOT NULL
- is_employee — varchar(255)
- enterpise_id — varchar(300)
- enterprise_name — varchar(200)
- representative_name — varchar(200)
- business_number — varchar(50)
- business_type — varchar(100)
- service_type — varchar(100)
- fax — varchar(50)
- employee_count — int(11)
- enterprise_auth — int(11)
- enterprise_description — text
- enterprise_files — longtext
- is_expert — tinyint(4) — NOT NULL
- is — agree_expert_conditions`
- expert_description — longtext
- expert_files — longtext
- response_day — int(11)
- start_response_time — time
- end_response_time — time
- average_respose_time — time
- average_evaluation — int(11)
- withdrawal_bank — varchar(100)
- bank_acount_number — varchar(100)
- bank_account_holder — varchar(100)
- withdrawal_reason — longtext
- create — datetime — NOT NULL
- update — datetime — NOT NULL
- status — int(11) — NOT NULL
smi_address
- address_idx — int(11) — Primary key — NOT NULL
- account_idx — int(11) — Foreign key → smi_account.account_idx — NOT NULL
- address — varchar(128) — NOT NULL
- detail_address — varchar(128) — NOT NULL
- zip — varchar(64)
- is_represent — tinyint(4) — NOT NULL
- create — datetime — NOT NULL
- update — datetime — NOT NULL
- status — int(11) — NOT NULL
smi_api_key
- api_key_index — int(11) — Primary key — NOT NULL
- id — text — NOT NULL
- secret — longtext — NOT NULL
- URL — varchar(100) — NOT NULL
- expiration — datetime — NOT NULL
- create — datetime — NOT NULL
- update — datetime — NOT NULL
- status — int(11) — NOT NULL
smi_blog
- blog_idx — int(11) — Primary key — NOT NULL
- account_idx — int(11) — Foreign key → smi_account.account_idx — NOT NULL
- title — varchar(500) — NOT NULL
- description — longtext — NOT NULL
- view_count — int(11) — NOT NULL
- create — datetime — NOT NULL
- update — datetime — NOT NULL
- status — int(11) — NOT NULL
smi_blue_print
- blue_print_idx — int(11) — Primary key — NOT NULL
- service_idx — int(11) — Foreign key → smi_service.service_idx — NOT NULL
- meterial_idx — int(11) — Foreign key → smi_meterial_type.meterial_idx — NOT NULL
- count — int(11) — NOT NULL
- description — varchar(3000)
- material — varchar(64)
- measure — varchar(64)
- color — varchar(64)
- file — longtext
- image — longtext
- create — datetime — NOT NULL
- update — datetime — NOT NULL
- status — int(11) — NOT NULL
smi_blue_print_history
- blue_print_history_idx — int(11) — Primary key — NOT NULL
- blue_print_idx — int(11) — Foreign key → smi_blue_print.blue_print_idx — NOT NULL
- meterial — varchar(200) — NOT NULL
- count — int(11) — NOT NULL
- description — varchar(3000)
- files — longtext — NOT NULL
- change_date — datetime — NOT NULL
smi_bookmark
- bookmark_idx — int(11) — Primary key — NOT NULL
- account_idx — int(11) — Foreign key → smi_account.account_idx — NOT NULL — PK AI
- id — int(11) — NOT NULL
- bookmark_name — varchar(1000) — NOT NULL
- like_or_not — tinyint(1) — NOT NULL
- create — datetime — NOT NULL
- update — datetime — NOT NULL
- status — int(11) — NOT NULL
smi_chat_account
- chat_account_idx — int(11) — Primary key — NOT NULL
- chatroom_idx — int(11) — Foreign key → smi_chatroom.chatroom_idx — NOT NULL
- account_idx — int(11) — Foreign key → smi_account.account_idx — NOT NULL
smi_chatmessage
- message_idx — int(11) — Primary key — NOT NULL
- chat_account_idx — int(11) — Foreign key → smi_chat_account.chat_account_idx — NOT NULL
- chatroom_idx — int(11) — Foreign key → smi_chatroom.chatroom_idx — NOT NULL
- message — varchar(5000) — NOT NULL
- create — datetime — NOT NULL
- status — int(11)
smi_chatroom
- chatroom_idx — int(11) — Primary key — NOT NULL
- create — datetime — NOT NULL
- update — datetime — NOT NULL
- status — int(11) — NOT NULL
smi_delivery
- delivery_idx — int(11) — Primary key — NOT NULL
- service_idx — int(11) — Foreign key → smi_service.service_idx — NOT NULL
- item — varchar(200) — NOT NULL
- count — int(11) — NOT NULL
- delivery_company — varchar(200) — NOT NULL
- transport_number — int(11) — NOT NULL
- delivery_api — varchar(200)
- create — datetime — NOT NULL
- update — datetime — NOT NULL
- status — int(11) — NOT NULL
smi_device
- factory_DEVICE_idx — int(11) — Primary key — NOT NULL
- factory_idx — int(11) — Foreign key → smi_factory.factory_idx — NOT NULL
- name — varchar(200) — NOT NULL
- count — int(11) — NOT NULL
- description — text — NOT NULL
- create — datetime — NOT NULL
- update — datetime — NOT NULL
- files — longtext
- status — int(11) — NOT NULL
smi_estimate
- estimate_idx — int(11) — Primary key — NOT NULL
- account_idx — int(11) — Foreign key → smi_account.account_idx — NOT NULL
- service_idx — int(11) — Foreign key → smi_service.service_idx — NOT NULL
- is_open — tinyint(4) — NOT NULL
- description — varchar(3000)
- due_date — datetime — NOT NULL
- prototype_count — int(11) — NOT NULL
- expiration — datetime — NOT NULL
- price — int(11) — NOT NULL
- files — longtext
- create — datetime — NOT NULL
- update — datetime — NOT NULL
- status — int(11) — NOT NULL
smi_estimate_history
- estimate_histoy_idx — int(11) — Primary key — NOT NULL
- estimate_idx — int(11) — Foreign key → smi_estimate.estimate_idx — NOT NULL
- description — varchar(3000)
- due_date — datetime — NOT NULL
- prototype_count — int(11) — NOT NULL
- expiration — datetime — NOT NULL
- estimate_price — int(11) — NOT NULL
- files — longtext
- change_date — datetime — NOT NULL
smi_estimate_item
- estimate_item_idx — int(11) — Primary key — NOT NULL
- estimate_idx — int(11) — Foreign key → smi_estimate.estimate_idx — NOT NULL
- name — varchar(100) — NOT NULL
- unit_price — int(11) — NOT NULL
- count — int(11) — NOT NULL
- unit_price_sum — int(11) — NOT NULL
- description — varchar(2000)
- material — varchar(64)
- measure — varchar(64)
- color — varchar(64)
- file — longtext
- image — longtext
- create — datetime — NOT NULL
- update — datetime — NOT NULL
- status — int(11) — NOT NULL
smi_estimate_item_history
- estimate_item_history_idx — int(11) — Primary key — NOT NULL
- estimate_item_idx — int(11) — Foreign key → smi_estimate_item.estimate_item_idx — NOT NULL
- name — varchar(100) — NOT NULL
- unit_price — int(11) — NOT NULL
- count — int(11) — NOT NULL
- total_price — int(11) — NOT NULL
- description — varchar(2000)
- files — longtext
- change_date — datetime — NOT NULL
smi_evaluation
- evaluation_idx — int(11) — Primary key — NOT NULL
- account_idx — int(11) — Foreign key → smi_account.account_idx — NOT NULL
- service_idx — int(11) — Foreign key → smi_service.service_idx — NOT NULL
- grade — int(11) — NOT NULL
- description — varchar(3000)
- duration — int(11) — NOT NULL
- is_price_open — tinyint(4) — NOT NULL
- price — int(11) — NOT NULL
- create — datetime — NOT NULL
- update — datetime — NOT NULL
- status — int(11) — NOT NULL
smi_event
- event_idx — int(11) — Primary key — NOT NULL
- send_idx — int(11) — NOT NULL
- send_id — varchar(256) — NOT NULL
- send_image_idx — int(11)
- recieve_idx — int(11) — NOT NULL
- recieve_id — varchar(256) — NOT NULL
- project_idx — int(11)
- service_idx — int(11)
- service_name — varchar(128)
- service_type_idx — varchar(128)
- event_type — varchar(64) — NOT NULL
- create — datetime — NOT NULL
- status — int(11) — NOT NULL
smi_expert_career
- expert_career_idx — int(11) — Primary key — NOT NULL
- account_idx — int(11) — Foreign key → smi_account.account_idx — NOT NULL
- is_freelancer — tinyint(4) — NOT NULL
- company_name — varchar(100)
- department — varchar(100)
- job_position — varchar(100)
- address — varchar(200)
- start_period — datetime — NOT NULL
- end_period — datetime — NOT NULL
- files — longtext
- create — datetime — NOT NULL
- update — datetime — NOT NULL
- status — int(11) — NOT NULL
smi_expert_license
- expert_license_idx — int(11) — Primary key — NOT NULL
- account_idx — int(11) — Foreign key → smi_account.account_idx — NOT NULL
- name — int(11) — NOT NULL
- issue_date — longtext — NOT NULL
- issuing_agency — varchar(100) — NOT NULL
- files — longtext
- create — datetime — NOT NULL
- update — datetime — NOT NULL
- status — int(11) — NOT NULL
smi_factory
- factory_idx — int(11) — Primary key — NOT NULL
- account_idx — int(11) — Foreign key → smi_account.account_idx — NOT NULL
- name — varchar(100) — NOT NULL
- factory_number — int(11) — NOT NULL
- address — varchar(500) — NOT NULL
- scale — varchar(200) — NOT NULL
- is_smart_factory — tinyint(4) — NOT NULL
- create — datetime — NOT NULL
- update — datetime — NOT NULL
- files — longtext
- status — int(11) — NOT NULL
smi_faq
- faq_idx — int(11) — Primary key — NOT NULL
- faq — longtext — NOT NULL
- create — datetime — NOT NULL
- update — datetime — NOT NULL
- status — int(11) — NOT NULL
smi_file
- file_idx — int(11) — Primary key — NOT NULL
- saved_name — varchar(500) — NOT NULL
- origin_name — varchar(200) — NOT NULL
- file_extension — varchar(20) — NOT NULL
- file_path — varchar(700) — NOT NULL
- file_type — varchar(100) — NOT NULL
- file_size — bigint(20) — NOT NULL
- create — datetime — NOT NULL
- update — datetime — NOT NULL
- status — int(11) — NOT NULL
smi_intereste_service
- interest_service_idx — int(11) — Primary key — NOT NULL
- service_type_idx — int(11) — Foreign key → smi_service_type.service_type_idx — NOT NULL
- account_idx — int(11) — Foreign key → smi_account.account_idx — NOT NULL
- type — int(11) — NOT NULL
- create — datetime — NOT NULL
- update — datetime — NOT NULL
- status — int(11) — NOT NULL
smi_jwt
- jwt_idx — int(11) — Primary key — NOT NULL
- jwt — text — NOT NULL
- type — varchar(100) — NOT NULL
- create — datetime — NOT NULL
- update — datetime — NOT NULL
- status — int(11) — NOT NULL
smi_meterial_type
- meterial_idx — int(11) — Primary key — NOT NULL
- meterial — varchar(200) — NOT NULL
- parents — varchar(200) — NOT NULL
- create — datetime — NOT NULL
- update — datetime — NOT NULL
- status — int(11) — NOT NULL
smi_notice
- notice_guide_idx — int(11) — Primary key — NOT NULL
- type — int(11) — NOT NULL
- notice — longtext — NOT NULL
- create — datetime — NOT NULL
- update — datetime — NOT NULL
- state — int(11) — NOT NULL
smi_order_item
- order_item_idx — int(11) — Primary key — NOT NULL
- service_idx — int(11) — Foreign key → smi_service.service_idx — NOT NULL
- name — varchar(200) — NOT NULL
- unit_price — int(11) — NOT NULL
- count — int(11) — NOT NULL
- made_count — int(11)
- total_price — int(11) — NOT NULL
- description — varchar(2000)
- file — longtext
- image — longtext
- create — datetime — NOT NULL
- update — datetime — NOT NULL
- status — int(11) — NOT NULL
- measure — varchar(64)
- color — varchar(64)
- material — varchar(64)
smi_order_item_history
- order_item_idx — int(11) — Primary key — NOT NULL
- order_item_idx2 — int(11) — Foreign key → smi_order_item.order_item_idx — NOT NULL
- name — varchar(200) — NOT NULL
- unit_price — int(11) — NOT NULL
- count — int(11) — NOT NULL
- total_price — int(11) — NOT NULL
- description — varchar(2000)
- files — longtext
- change_date — datetime — NOT NULL
smi_payment
- payment_idx — int(11) — Primary key — NOT NULL
- payment_type — _idx` — NOT NULL
- service_idx — int(11) — Foreign key → smi_service.service_idx — NOT NULL
- payment — int(11) — NOT NULL
- create — datetime — NOT NULL
- status — int(11) — NOT NULL
smi_payment_type
- payment_type — _idx` — Primary key — NOT NULL
- payment_type — varchar(100) — NOT NULL
- description — varchar(700) — NOT NULL
- create — datetime — NOT NULL
- update — datetime — NOT NULL
- status — int(11) — NOT NULL
smi_post_process
- post_process_idx — int(11) — Primary key — NOT NULL
- blue_print_idx — int(11) — Foreign key → smi_blue_print.blue_print_idx — NOT NULL
- post_process_type_idx — int(11) — Foreign key → smi_post_process_type.post_process_type_idx — NOT NULL
- description — varchar(2000)
- create — datetime — NOT NULL
- update — datetime — NOT NULL
- status — int(11) — NOT NULL
smi_post_process_history
- post_process_history_idx — int(11) — Primary key — NOT NULL
- post_process_idx — int(11) — Foreign key → smi_post_process.post_process_idx — NOT NULL
- post_process_type — varchar(200) — NOT NULL
- description — varchar(2000)
- change_date — datetime — NOT NULL
smi_post_process_type
- post_process_type_idx — int(11) — Primary key — NOT NULL
- post_process_type — varchar(200) — NOT NULL
- create — datetime — NOT NULL
- update — datetime — NOT NULL
- status — int(11) — NOT NULL
smi_project
- project_idx — int(11) — Primary key — NOT NULL
- account_idx — int(11) — Foreign key → smi_account.account_idx — NOT NULL
- name — varchar(200) — NOT NULL
- create — datetime — NOT NULL
- update — datetime — NOT NULL
- status — int(11) — NOT NULL
smi_reason
- discontinue_reason_idx — int(11) — Primary key — NOT NULL
- type — int(11) — NOT NULL
- reason — varchar(300) — NOT NULL
- create — datetime — NOT NULL
- update — datetime — NOT NULL
- status — int(11) — NOT NULL
smi_sended_code
- code_idx — int(11) — Primary key — NOT NULL
- code — varchar(10) — NOT NULL
- email — varchar(100) — NOT NULL
- type — varchar(50) — NOT NULL
- create — datetime — NOT NULL
- expiration — datetime — NOT NULL
- status — int(11) — NOT NULL
smi_sensor
- sensor_idx — int(11) — Primary key — NOT NULL
- factory_idx — int(11) — Foreign key → smi_factory.factory_idx — NOT NULL
- factory_equipment_idx — int(11) — Foreign key → smi_device.factory_DEVICE_idx — NOT NULL
- name — varchar(50)
- type — varchar(50) — NOT NULL
- create — datetime — NOT NULL
- update — datetime — NOT NULL
- status — int(11) — NOT NULL
smi_sensor_control_log
- sensor_control_log_idx — int(11) — Primary key — NOT NULL
- sensor_idx — int(11) — Foreign key → smi_sensor.sensor_idx — NOT NULL
- event_code — int(11) — NOT NULL
- event_time — datetime(3) — NOT NULL
smi_sensor_data
- sensor_data_idx — int(11) — Primary key — NOT NULL
- sensor_idx — int(11) — Foreign key → smi_sensor.sensor_idx — NOT NULL
- equipment_id — int(11) — NOT NULL
- sensor_data — longtext — NOT NULL
- collection_time — timestamp — NOT NULL
smi_service
- service_idx — int(11) — Primary key — NOT NULL
- service_type_idx — int(11) — Foreign key → smi_service_type.service_type_idx — NOT NULL
- project_idx — int(11) — Foreign key → smi_project.project_idx — NOT NULL
- name — varchar(300) — NOT NULL
- is_open — tinyint(4) — NOT NULL
- purpose — varchar(300) — NOT NULL
- parent_stage — varchar(64) — NOT NULL
- child_stage — varchar(64) — NOT NULL
- is_budget_open — tinyint(4) — NOT NULL
- budget — bigint(20) — NOT NULL
- is_blue_print_open — tinyint(4) — NOT NULL
- log — longtext — NOT NULL
- is_designation — int(11) — NOT NULL
- designation_team — int(11) — NOT NULL
- service_description — varchar(2000) — NOT NULL
- is_delivery_date_nego — tinyint(4) — NOT NULL
- desired_delivery_date — datetime
- prototype_count — int(11) — NOT NULL
- expiration — datetime — NOT NULL
- viewer_count — int(11)
- service_files — longtext
- is_ordered — tinyint(4) — NOT NULL
- order_confirm — tinyint(4)
- order_number — varchar(200)
- order_date — datetime
- delivery_date — datetime
- order_description — varchar(2000)
- sum_total_price — int(11)
- order_files — longtext
- client_verify_files — longtext
- team_verify_files — longtext
- discontinue_reason — longtext
- create — datetime — NOT NULL
- update — datetime — NOT NULL
- status — int(11) — NOT NULL
- team_idx — int(11)
- team_name — varchar(300)
- service_image — longtext
- temp_delivery_Fee — int(11)
smi_service_history
- service_idx — int(11) — Primary key — NOT NULL
- service_idx2 — int(11) — Foreign key → smi_service.service_idx — NOT NULL
- name — varchar(300) — NOT NULL
- is_open — tinyint(4) — NOT NULL
- purpose — varchar(300) — NOT NULL
- stage — varchar(200) — NOT NULL
- is_budget_open — tinyint(4) — NOT NULL
- budget — bigint(20) — NOT NULL
- is_blue_print_open — tinyint(4) — NOT NULL
- log — longtext — NOT NULL
- is_designation — int(11) — NOT NULL
- designation_team — int(11) — NOT NULL
- description — varchar(2000) — NOT NULL
- is_delivery_date_nego — tinyint(4) — NOT NULL
- request_date — datetime — NOT NULL
- prototype_count — int(11) — NOT NULL
- expiration — datetime — NOT NULL
- viewer_count — int(11)
- service_files — longtext
- is_ordered — tinyint(4) — NOT NULL
- order_number — varchar(200)
- due_date — datetime
- order_description — varchar(2000)
- sum_total_price — int(11)
- order_files — longtext
- discontinue_reason — longtext
- change_date — datetime — NOT NULL
smi_service_type
- service_type_idx — int(11) — Primary key — NOT NULL
- name — varchar(20) — NOT NULL
- form — longtext — NOT NULL
- parents — int(11)
- create — datetime — NOT NULL
- update — datetime — NOT NULL
- status — int(11) — NOT NULL