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