Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE Entity (
- id INTEGER PRIMARY KEY,
- name VARCHAR(100),
- schema VARCHAR(400)
- );
- CREATE TABLE FIELD (
- id INTEGER PRIMARY KEY,
- entity_id INTEGER REFERENCES Entity(id),
- TYPE VARCHAR(20),
- name VARCHAR(100)
- );
- CREATE TABLE Instance (
- id INTEGER PRIMARY KEY,
- entity_id INTEGER REFERENCES Entity(id),
- DATA BLOB
- );
- CREATE TABLE InstanceField (
- id INTEGER PRIMARY KEY,
- field_id INTEGER REFERENCES FIELD(id),
- instance_id INTEGER REFERENCES Instance(id),
- VALUE VARCHAR(100)
- );
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement