MINILIFE

Tables (5)

COMMENT

  • comment_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → USER.user_id — NOT NULL
  • content_id — BIGINT — Foreign key → CONTENT.content_id — NOT NULL
  • comment (Field) — VARCHAR2 — NOT NULL
  • created_dt (Field2) — DATETIME — NOT NULL
  • updated_dt (Field3) — DATETIME — NOT NULL
  • deleted_dt (Field4) — DATETIME

CONTENT

  • content_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → USER.user_id — NOT NULL
  • uuid (Field) — VARCHAR2 — NOT NULL
  • title — VARCHAR2 — NOT NULL
  • body — MEDIUMTEXT
  • complete — TINYINT — NOT NULL
  • views — BIGINT — NOT NULL
  • created_dt — DATETIME — NOT NULL
  • updated_dt — DATETIME — NOT NULL
  • deleted_dt — DATETIME

CONTENT_TAG (Untitled)

  • Key — Primary key — NOT NULL
  • content_id — BIGINT — Foreign key → CONTENT.content_id — NOT NULL
  • category_id — BIGINT — Foreign key → TAG.category_id — NOT NULL
  • created_at (Field) — DATETIME — NOT NULL
  • updated_at (Field2) — DATETIME — NOT NULL

TAG (CATEGORY)

  • category_id — BIGINT — Primary key — NOT NULL
  • tag_name (Field) — VARCHAR2 — NOT NULL
  • created_at (Field2) — DATETIME — NOT NULL
  • updated_at (Field3) — DATETIME — NOT NULL

USER

  • user_id — BIGINT — Primary key — NOT NULL
  • email (password) — VARCHAR2 — NOT NULL
  • nickname (oauth_id) — VARCHAR2
  • oauth_id (oauth_provider) — BIGINT
  • oauth_provider (role) — VARCHAR2 — NOT NULL
  • role (created_dt) — TINYINT — NOT NULL
  • created_dt (updated_dt) — DATETIME — NOT NULL
  • updated_dt (deleted_dt) — DATETIME — NOT NULL
  • deleted_dt (Field) — DATETIME