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)