unbound

Tables (19)

Admins (관리자)

  • no (PK) — bigint — Primary key — NOT NULL
  • id — string
  • password — string
  • email — string

Application (어플리케이션)

  • no (PK) — bigint — Primary key — NOT NULL
  • application_name_eng — string
  • application_name_chn — string
  • application_image1 — string
  • application_image2 — string
  • application_image3 — string
  • application_image4 — string
  • application_image5 — string
  • application_image6 — string
  • application_image7 — string
  • application_image8 — string
  • application_image9 — string
  • application_image10 — string
  • application_image11 — string
  • application_image12 — string
  • app_img_text_eng1 — string
  • app_img_text_eng2 — string
  • app_img_text_eng3 — string
  • app_img_text_eng4 — string
  • app_img_text_eng5 — string
  • app_img_text_eng6 — string
  • app_img_text_eng7 — string
  • app_img_text_eng8 — string
  • app_img_text_eng9 — string
  • app_img_text_eng10 — string
  • app_img_text_eng11 — string
  • app_img_text_eng12 — string
  • app_img_text_chn1 — string
  • app_img_text_chn2 — string
  • app_img_text_chn3 — string
  • app_img_text_chn4 — string
  • app_img_text_chn5 — string
  • app_img_text_chn6 — string
  • app_img_text_chn7 — string
  • app_img_text_chn8 — string
  • app_img_text_chn9 — string
  • app_img_text_chn10 — string
  • app_img_text_chn11 — string
  • app_img_text_chn12 — string
  • sequence — int

Coating_info (코팅 정보)

  • no (PK) — bigint — Primary key — NOT NULL
  • coating_title — string
  • coating_content — string
  • created_at — timestamp
  • coating_image — string
  • coating_sequence — int
  • language (언어 구분) — string

Coating_part (코팅 부품)

  • no (PK) — bigint — Primary key — NOT NULL
  • category — string
  • production_line — string
  • equipment_company — string
  • name — string
  • name_chn — string
  • quantity — int
  • required_time — int
  • difficulty — string
  • a — string
  • b — string
  • width — int
  • depth — int
  • height — int
  • thickness — int
  • coating_side_length — int
  • coating_side_thickness — int
  • image — string
  • Field

Coating_service_estimate (코팅 서비스 견적)

  • no (PK) — bigint — Primary key — NOT NULL
  • powder_name — string
  • material — string
  • product_name — string
  • consumption — int
  • thickness — int
  • gas1 — string
  • gas2 — string
  • gas3 — string
  • price — int

Coating_service_log (코팅 서비스 견적 조회 기록)

  • no (PK) — bigint — Primary key — NOT NULL
  • user_no — bigint — Foreign key → Users.no — NOT NULL
  • part_name — string
  • service_name — string
  • coating_thickness — int
  • width — int
  • depth — int
  • height — int
  • price — int
  • inquiry_time — timestamp

Coating_set (코팅 세트)

  • no (PK) — bigint — Primary key — NOT NULL
  • name_eng — string
  • name_chn — string
  • set_price — int
  • set_sequence — int
  • Field

Coating_set_parts (코팅 세트 부품)

  • no (PK) — bigint — Primary key — NOT NULL
  • set_no — bigint — Foreign key → Coating_set.no — NOT NULL
  • parts_name — string
  • material — string
  • size — string
  • spec — string
  • quantity — int
  • parts_sequence — int
  • Field

ConsumeDB (소모성 DB)

  • no (PK) — bigint — Primary key — NOT NULL
  • name — string
  • unit — int
  • price — int
  • Field

FAQ (자주 묻는 질문)

  • no (PK) — bigint — Primary key — NOT NULL
  • faq_title — string
  • faq_content — string
  • created_at — timestamp
  • updated_at — timestamp
  • hit — int
  • sequence — int
  • language (언어 구분) — string
  • division — int

Home_file (홈 관리)

  • image1 — string
  • image1_title — string
  • image2 — string
  • image2_title — string
  • image3 — string
  • image3_title — string
  • powder_list_file — string
  • language (언어 구분) — string

Inquiry (고객 문의)

  • no (PK) — bigint — Primary key — NOT NULL
  • user_no — bigint — Foreign key → Users.no — NOT NULL
  • division — int
  • industry — string
  • equipment — string
  • file — string
  • name — string
  • title — string
  • message — string
  • created_at — timestamp

Intro_video (소개 영상)

  • no (PK) — bigint — Primary key — NOT NULL
  • video_title — string
  • video_file_name — string
  • video_thumbnail — string
  • video_sequence — int
  • language (언어 구분) — string
  • division — int
  • sequence — int

News (뉴스)

  • news_no (news_PK) — bigint — Primary key — NOT NULL
  • news_title — string
  • news_content — string
  • news_url — string
  • news_thumbnail — string
  • created_at — timestamp
  • news_hit — int
  • language (언어 구분) — string

Powder (파우더)

  • no (PK) — bigint — Primary key — NOT NULL
  • formula — string
  • powder_name — string
  • weight — int
  • powder_price — int
  • purity — int
  • morphology_eng — string
  • morphology_chn — string
  • color_eng — string
  • color_chn — string
  • particle_size_d10 — int
  • particle_size_d50 — int
  • particle_size_d90 — int
  • image1 — string
  • image2 — string
  • image3 — string
  • image4 — string
  • image5 — string
  • image6 — string
  • composition — string
  • size — int
  • price1 — int
  • price2 — int
  • price3 — int
  • price4 — int
  • price5 — int
  • price6 — int
  • price7 — int
  • price8 — int

Powder_log (파우더 견적조회 기록)

  • no (PK) — bigint — Primary key — NOT NULL
  • user_no — bigint — Foreign key → Users.no — NOT NULL
  • formula — string
  • powder_name — string
  • weightw (weight) — int
  • powder_price — int
  • inquiry_time — timestamp

Staff (직원)

  • no (PK) — bigint — Primary key — NOT NULL
  • name — string
  • annual_income — int
  • hourly_wage — int
  • calcu_method — string
  • Field

Users (회원)

  • no (user_pk) — bigint — Primary key — NOT NULL
  • email — string
  • password — string
  • company_name — string
  • business_card — string
  • user_status — int
  • created_at — timestamp
  • last_login_time — timestamp

message_log (메세지 전송 내역)

  • no (PK) — bigint — Primary key — NOT NULL
  • user_no — bigint — Foreign key → Users.no — NOT NULL
  • message — string
  • created_at — timestamp