vofee-v1

Tables (6)

COMMENT

  • id — INT — Primary key — NOT NULL
  • content — VARCHAR(191) — NOT NULL
  • created_at — DATETIME(3) — NOT NULL
  • updated_at — DATETIME(3) — NOT NULL
  • deleted_at — DATETIME(3)
  • fk_user_id — INT — Foreign key → USER.id — NOT NULL
  • fk_post_id — INT — Foreign key → POST.id — NOT NULL
  • fk_parent_comment_id — INT — Foreign key → COMMENT.id
  • fk_comment_id — INT — Foreign key → COMMENT.id
  • INDEX — `fk_post_id`
  • INDEX — `fk_user_id`
  • INDEX — `fk_parent_comment_id`
  • INDEX — `fk_comment_id`

COMMNET_RECORD

  • id — INT — Primary key — NOT NULL
  • fk_comment_id — INT — Foreign key → COMMENT.id — NOT NULL
  • fk_record_id — INT — Foreign key → RECORD.id — NOT NULL

POST

  • id — INT — Primary key — NOT NULL
  • fk_user_id — INT — Foreign key → USER.id — NOT NULL
  • created_at — DATETIME(3) — NOT NULL
  • updated_at — DATETIME(3) — NOT NULL
  • deleted_at — DATETIME(3)
  • INDEX — `fk_user_id`

POST_RECORD

  • id — INT — Primary key — NOT NULL
  • fk_post_id — INT — Foreign key → POST.id — NOT NULL
  • fk_record_id — INT — Foreign key → RECORD.id — NOT NULL

RECORD

  • id — INT — Primary key — NOT NULL
  • url — VARCHAR(191) — NOT NULL
  • is_expired — TINYINT(1) — NOT NULL
  • expired_at — DATETIME(3) — NOT NULL
  • fk_user_id — INT — Foreign key → USER.id — NOT NULL
  • INDEX — `fk_user_id`

USER

  • id — INT — Primary key — NOT NULL
  • nickname — VARCHAR(191) — NOT NULL
  • avatar — VARCHAR(191)
  • kakao_id — VARCHAR(191)
  • google_id — VARCHAR(191)
  • apple_id — VARCHAR(191)
  • created_at — DATETIME(3) — NOT NULL
  • updated_at — DATETIME(3) — NOT NULL
  • deleted_at — DATETIME(3)