OpenKM OKM_DB_METADATA_TYPE Example

okm_db_metadata_type

--DELETE FROM OKM_DB_METADATA_TYPE WHERE DMT_TABLE='vendor';
INSERT INTO OKM_DB_METADATA_TYPE (DMT_TABLE, DMT_REAL_COLUMN, DMT_TYPE, DMT_VIRTUAL_COLUMN) VALUES ('vendor', 'col00', 'integer', 'vendor_id');
INSERT INTO OKM_DB_METADATA_TYPE (DMT_TABLE, DMT_REAL_COLUMN, DMT_TYPE, DMT_VIRTUAL_COLUMN) VALUES ('vendor', 'col01', 'text', 'vendor_name');

--DELETE FROM OKM_DB_METADATA_VALUE WHERE DMV_TABLE='vendor';
INSERT INTO OKM_DB_METADATA_VALUE (DMV_TABLE, DMV_COL00, DMV_COL01) VALUES ('vendor', '001', 'Capsule Corp.');
INSERT INTO OKM_DB_METADATA_VALUE (DMV_TABLE, DMV_COL00, DMV_COL01) VALUES ('vendor', '002', 'Planet Express');
INSERT INTO OKM_DB_METADATA_VALUE (DMV_TABLE, DMV_COL00, DMV_COL01) VALUES ('vendor', '003', 'ACME');

SELECT * FROM OKM_DB_METADATA_VALUE WHERE DMV_TABLE='vendor'