천안 림/롤 대표 상표

테이블 (12)

Customer (Untitled)

  • Customer (ls_customer_code) — VARCHAR — 기본 키 — NOT NULL
  • PaperType (ls_paper_type) — BIGINT — 기본 키
  • Color (ls_color) — VARCHAR
  • Pattern (ls_pattern) — VARCHAR
  • Itchar (itchar) — INT

FSC마크 (Untitled6)

  • PaperType (ls_paper_type) — BIGINT — 기본 키 — NOT NULL
  • FSC code — VARCHAR
  • Customer (ls_customer_code) — VARCHAR — 외래 키 → Customer.Customer — NOT NULL
  • PaperType (ls_paper_type2) — BIGINT — 외래 키 → Customer.PaperType

Paper (Untitled10)

  • PaperType (ls_paper_type) — BIGINT — 기본 키 — NOT NULL
  • Customer (ls_cust_code) — VARCHAR

[지종 / 패턴 ] 정보 인쇄 (Untitled9)

  • PaperType (ls_paper_type) — BIGINT — 기본 키
  • Customer (ls_customer_code) — VARCHAR — NOT NULL
  • Export (ls_export_yn) — Boolean
  • LI_CNT_AM — INT
  • Itchar (is_itchar) — INT
  • Pattern (ls_pattern) — VARCHAR
  • 지종명 — VARCHAR
  • 패턴 (패턴턴) — VARCHAR
  • 영문 표시 — VARCHAR
  • Customer (ls_customer_code2) — VARCHAR — 외래 키 → Customer.Customer — NOT NULL
  • PaperType (ls_paper_type2) — BIGINT — 외래 키 → Customer.PaperType

광택 (Untitled7)

  • PaperType (ls_paper_type) — BIGINT — 기본 키
  • Customer (ls_customer_code) — VARCHAR — NOT NULL
  • Itchar (is_itchar) — INT
  • Pattern (ls_pattern) — VARCHAR
  • 광택 — Boolean
  • Customer (ls_customer_code2) — VARCHAR — 외래 키 → Customer.Customer — NOT NULL
  • PaperType (ls_paper_type2) — BIGINT — 외래 키 → Customer.PaperType

내수 대표상표 및 타 지종 상표 (Untitled12)

  • PaperType (ls_paper_type) — BIGINT — 기본 키 — NOT NULL
  • Export (ls_export) — Boolean
  • Nocount (li_nocount) — INT
  • 지종명 — VARCHAR
  • PaperType (ls_paper_type2) — BIGINT — 외래 키 → Paper.PaperType — NOT NULL

몽블랑, FSCD 영문 색상 (Untitled8)

  • Customer (ls_customer_code) — VARCHAR — 기본 키 — NOT NULL
  • PaperType (ls_paper_type) — BIGINT
  • Itchar (is_itchar) — INT
  • Pattern (ls_pattern) — VARCHAR
  • 색상명 — VARCHAR
  • Customer (ls_customer_code2) — VARCHAR — 외래 키 → 영문 색상명.Customer — NOT NULL
  • PaperType (ls_paper_type2) — BIGINT — 외래 키 → 영문 색상명.PaperType

수출 인쇄 유무 (Untitled5)

  • PaperType (ls_paper_type) — BIGINT — 기본 키
  • Customer (ls_customer_code) — VARCHAR — NOT NULL
  • Export (ls_export_yn) — Boolean
  • Pattern (ls_pattern) — VARCHAR
  • Itchar (is_itchar) — INT
  • 수출 인쇄 — Boolean
  • Customer (ls_customer_code2) — VARCHAR — 외래 키 → Customer.Customer — NOT NULL
  • PaperType (ls_paper_type2) — BIGINT — 외래 키 → Customer.PaperType

영문 색상명 (Untitled2)

  • Customer (ls_customer_code) — VARCHAR — 기본 키 — NOT NULL
  • Color (ls_color) — VARCHAR
  • EngColor (ls_color_eng) — VARCHAR
  • Customer (ls_customer_code2) — VARCHAR — 외래 키 → Customer.Customer — NOT NULL
  • PaperType (ls_paper_type) — BIGINT — 외래 키 → Customer.PaperType

영문지종명 변경인쇄 (Untitled11)

  • PaperType (ls_paper_type) — BIGINT — 기본 키
  • Customer (ls_cust_code) — VARCHAR — NOT NULL
  • Paper_nm_eng (ls_paper_nm_eng) — VARCHAR
  • PaperType (ls_paper_type2) — BIGINT — 외래 키 → Paper.PaperType — NOT NULL

인도 고객사 인스퍼 M (Untitled3)

  • PaperType (ls_paper_type) — BIGINT — 기본 키
  • Customer (ls_customer_code) — VARCHAR — NOT NULL
  • EngPaper (ls_paper_eng) — VARCHAR
  • Jijong (ls_jijong_name) — VARCHAR
  • Customer (ls_customer_code2) — VARCHAR — 외래 키 → Customer.Customer — NOT NULL
  • PaperType (ls_paper_type2) — BIGINT — 외래 키 → Customer.PaperType

한글 인쇄 유무 (Untitled4)

  • PaperType (ls_paper_type) — BIGINT — 기본 키
  • Customer (ls_customer_code) — VARCHAR — NOT NULL
  • Pattern (ls_pattern) — VARCHAR
  • Itchar (is_itchar) — INT
  • 한글 인쇄 — Boolean
  • Customer (ls_customer_code2) — VARCHAR — 외래 키 → Customer.Customer — NOT NULL
  • PaperType (ls_paper_type2) — BIGINT — 외래 키 → Customer.PaperType