データベース設計メモ.md

データベース設計

ZITEM

CREATE TABLE ZITEM (
	Z_PK INTEGER PRIMARY KEY,
	Z_ENT INTEGER, 
	Z_OPT INTEGER,
	ZPRIVATE INTEGER,
	ZCREATED_AT TIMESTAMP,
	ZPOSTED_AT TIMESTAMP, 
	ZUPDATED_AT TIMESTAMP, 
	ZBODY VARCHAR, 
	ZLINKED_FILE VARCHAR, 
	ZRAW_BODY VARCHAR, 
	ZTITLE VARCHAR, 
	ZURL VARCHAR, 
	ZUUID VARCHAR 
);

ZTAG

CREATE TABLE ZTAG ( 
	Z_PK INTEGER PRIMARY KEY, 
	Z_ENT INTEGER, 
	Z_OPT INTEGER, 
	ZNAME VARCHAR 
);

Z_1TAGS

CREATE TABLE Z_1TAGS ( 
	Z_1ITEMS INTEGER, 
	Z_2TAGS INTEGER, 
	PRIMARY KEY (Z_1ITEMS, Z_2TAGS) 
);

Z_METADATA

CREATE TABLE Z_METADATA (
	Z_VERSION INTEGER PRIMARY KEY, 
	Z_UUID VARCHAR(255), 
	Z_PLIST BLOB
);

Z_PRIMARYKEY

CREATE TABLE Z_PRIMARYKEY (
	Z_ENT INTEGER PRIMARY KEY, 
	Z_NAME VARCHAR, 
	Z_SUPER INTEGER, 
	Z_MAX INTEGER
);

ZITEM_ZCREATED_AT_INDEX

CREATE INDEX ZITEM_ZCREATED_AT_INDEX ON ZITEM (ZCREATED_AT);

ZITEM_ZUPDATED_AT_INDEX

CREATE INDEX ZITEM_ZUPDATED_AT_INDEX ON ZITEM (ZUPDATED_AT);

ZTAG_ZNAME_INDEX

CREATE INDEX ZTAG_ZNAME_INDEX ON ZTAG (ZNAME);