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