historia
Tables (6)
image (HT_IMAGE)
- image_id (HT_IMAGE_ID) — BIGINT — Primary key — NOT NULL
- image_path (HT_IMAGE_PATH) — MEDIUMTEXT
- image_title (HT_IMAGE_NAME) — VARCHAR(256)
- regdate (HT_IMAGE_REG) — DATETIME
- status (HT_IMAGE_STATUS) — INT(11)
- user_idx (HT_USER_IDX) — BIGINT — Foreign key → users.user_idx — NOT NULL
keywords (HT_KEYWORD)
- keyword_id (HT_KEY_ID) — BIGINT — Primary key — NOT NULL
- keyword (HT_KEY_VAL) — VARCHAR(256)
- locale (HT_KEY_LCL) — INT(11)
- keyword_type (HT_KEY_TYPE) — INT(11)
- regdate (HT_KEY_REG) — DATETIME
- reference (HT_KEY_REF) — MEDIUMTEXT
- status (HT_KEY_STATUS) — INT(11)
- user_idx (HT_USER_IDX) — BIGINT — Foreign key → users.user_idx — NOT NULL
news (HT_NEWS)
- news_id (HT_NEWS_ID) — BIGINT — Primary key — NOT NULL
- publisher_id (HT_PUBLISH_ID) — BIGINT
- origin (HT_NEWS_URL) — MEDIUMTEXT
- origindate (HT_NEWS_DATE) — DATETIME
- regdate (HT_NEWS_REG) — DATETIME
- body (HT_NEWS_BODY) — MEDIUMTEXT
- status (HT_NEWS_STATUS) — INT(11)
- user_idx (HT_USER_IDX) — BIGINT — Foreign key → users.user_idx — NOT NULL
news_info (HT_NINFO)
- news_info_id (HT_NINFO_ID) — BIGINT — Primary key — NOT NULL
- news_id (HT_NEWS_ID) — BIGINT — Foreign key → news.news_id — NOT NULL
- news_info_type (HT_NINFO_TYPE) — INT(11)
- news_info_value (HT_NINFO_VAL) — VARCHAR(256)
newskey (NEWS_KEY)
- news_id (HT_NEWS_ID) — BIGINT — Foreign key → news.news_id — NOT NULL
- keyword_id (HT_KEY_ID) — BIGINT — Foreign key → keywords.keyword_id — NOT NULL
- regdate (NEWS_KEY_REG) — DATETIME
- type (NEWS_KEY_TYPE) — INT(11)
users (HT_USER)
- user_idx (HT_USER_IDX) — BIGINT — Primary key — NOT NULL
- user_id (HT_USER_ID) — VARCHAR(256)
- user_pass (HT_USER_PASS) — VARCHAR(256)
- user_perm (HT_USER_PERM) — INT(11)
- regdate (HT_USER_REG) — DATETIME
- modify (HT_USER_MOD) — DATETIME
- status (HT_USER_STATUS) — INT(11)