kakao

Tables (6)

auth

  • auth_id — BIGINT
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • refresh_token — VARCHAR(512) — NOT NULL
  • expired_at — DATETIME — NOT NULL
  • revoked_at — DATETIME
  • created_at — DATETIME — NOT NULL

comments

  • comment_id — BIGINT
  • post_id — BIGINT — Foreign key → posts.post_id — NOT NULL
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • content — VARCHAR(1000) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • deleted_at — DATETIME

files

  • file_id — BIGINT
  • uploaded_by_user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • file_url — VARCHAR(500) — NOT NULL
  • file_name — VARCHAR(255) — NOT NULL
  • content_type — VARCHAR(100) — NOT NULL
  • size_bytes — BIGINT — NOT NULL
  • created_at — DATETIME — NOT NULL

post_likes

  • post_id — BIGINT — Foreign key → posts.post_id — NOT NULL
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • created_at — DATETIME — NOT NULL

posts

  • post_id — BIGINT
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • image_file_id — BIGINT — Foreign key → files.file_id
  • title — VARCHAR(26) — NOT NULL
  • content — TEXT — NOT NULL
  • view_count — INT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • deleted_at — DATETIME

users

  • user_id — BIGINT
  • email — VARCHAR(255) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • nickname — VARCHAR(50) — NOT NULL
  • profile_image_file_id — BIGINT — Foreign key → files.file_id
  • status — VARCHAR(20) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • deleted_at — DATETIME