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