MyLog
Tables (9)
article
- id — BIGSERIAL
- member_id — BIGINT — Foreign key → member.id — NOT NULL
- category_id — BIGINT — Foreign key → category.id
- title — VARCHAR(30) — NOT NULL
- content — VARCHAR(3000) — NOT NULL
- article_img — VARCHAR(300)
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
article_ai_analyze
- post_id (article_id) — BIGINT
- summary — TEXT
- analyze_status — ai_analyze_status — NOT NULL
- raw_response — JSONB
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
article_tag
- article_id — BIGINT — Foreign key → article.id — NOT NULL
- tag_id — BIGINT — Foreign key → tag.id — NOT NULL
category
- id — BIGSERIAL
- category_name — VARCHAR(12)
- member_id — BIGINT — Foreign key → member.id — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
comment
- id — BIGSERIAL
- article_id — BIGINT — Foreign key → article.id — NOT NULL
- member_id — BIGINT — Foreign key → member.id — NOT NULL
- parent_id — BIGINT — Foreign key → comment.id
- content — VARCHAR(200)
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
member
- id — BIGSERIAL
- email — VARCHAR(30)
- password — VARCHAR(150)
- member_name — VARCHAR(30) — NOT NULL
- nickname — VARCHAR(100)
- profile_img — VARCHAR(300) — NOT NULL
- bio — VARCHAR(200)
- provider — oauth_provider — NOT NULL
- provider_id — VARCHAR(200)
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
notification
- id — BIGSERIAL
- member_id — BIGINT — Foreign key → member.id — NOT NULL
- type — TEXT — NOT NULL
- related_id — BIGINT — NOT NULL
- read — BOOLEAN — NOT NULL
- created_at — TIMESTAMP — NOT NULL
notification_setting
- id — BIGSERIAL
- member_id — BIGINT — Foreign key → member.id — NOT NULL
- type — VARCHAR(20) — NOT NULL
- disabled — BOOLEAN — NOT NULL
- created_at — TIMESTAMP — NOT NULL
tag
- id — BIGSERIAL
- tag_name — VARCHAR(10) — NOT NULL
- created_at — DATE — NOT NULL