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