ㅁㄴㅇ

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