ISAC-FARMEWORK

Tables (6)

license_history (라이센스이력)

  • Key — Integer — Primary key — NOT NULL
  • Key (Key2) — Integer — Foreign key → license_issue.Key — NOT NULL
  • Key (Key22) — VARCHAR — Foreign key → license_issue.Key — NOT NULL
  • Field3 — VARCHAR
  • Field4 — VARCHAR
  • Field5 — VARCHAR
  • Field6 — VARCHAR
  • Field7 — VARCHAR
  • Field8 — VARCHAR
  • Field9 — VARCHAR
  • Field10 — VARCHAR
  • Field11 — VARCHAR
  • Field12 — VARCHAR
  • Field13 — VARCHAR
  • Field14 — VARCHAR
  • Field15 — VARCHAR
  • Field16 — TIMESTAMP
  • Field17 — VARCHAR
  • Field18 — VARCHAR
  • Field19 — TIMESTAMP

license_issue (라이센스이슈)

  • Key — Integer — Primary key — NOT NULL
  • Key (Key2) — VARCHAR — Foreign key → t_product.Key — NOT NULL
  • Field2 — VARCHAR
  • Field3 — VARCHAR
  • Field4 — VARCHAR
  • Field5 — VARCHAR
  • Field6 — VARCHAR
  • Field7 — VARCHAR
  • Field8 — VARCHAR
  • Field9 — VARCHAR
  • Field10 — VARCHAR
  • Field11 — TIMESTAMP
  • Field12 — VARCHAR
  • Field13 — VARCHAR
  • Field — VARCAHR

t_customer (고객)

  • Key — VARCHAR — Primary key — NOT NULL
  • Field — VARCHAR
  • Field2 — VARCHAR
  • Field3 — Integer
  • Field4 — VARCHAR

t_customer_history (고객이력)

  • Key — Integer — Primary key — NOT NULL
  • Key (Key2) — VARCHAR — Foreign key → t_customer.Key — NOT NULL
  • Field — VARCHAR
  • Field2 — VARCHAR
  • Field3 — Integer
  • Field4 — VARCHAR
  • Field5 — TIMESTAMP

t_customer_product (고객사별제품)

  • Key — VARCHAR — Foreign key → t_customer.Key — NOT NULL
  • Key (Key2) — VARCHAR — Foreign key → t_product.Key — NOT NULL

t_product (제품)

  • Key — VARCHAR — Primary key — NOT NULL
  • Field — VARCHAR