MoneyWay

Tables (7)

comment

  • id — BIGINT
  • post_id — BIGINT — NOT NULL
  • user_id — BIGINT — NOT NULL
  • content — TEXT — NOT NULL
  • deleted — BOOLEAN — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME

post

  • id — BIGINT
  • user_id — BIGINT — NOT NULL
  • title — VARCHAR(50) — NOT NULL
  • content — TEXT — NOT NULL
  • total_cost — INT — NOT NULL
  • is_challenge — BOOLEAN — NOT NULL
  • like_count — INT — NOT NULL
  • comment_count — INT — NOT NULL
  • scrap_count — INT — NOT NULL
  • view_count — INT — NOT NULL
  • thumbnail_url — TEXT
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME

post_image

  • id — BIGINT
  • post_id — BIGINT — NOT NULL
  • image_url — TEXT — NOT NULL

post_like

  • id — BIGINT
  • post_id — BIGINT — NOT NULL
  • user_id — BIGINT — NOT NULL

post_scrap

  • id — BIGINT
  • post_id — BIGINT — NOT NULL
  • user_id — BIGINT — NOT NULL

post_view

  • id — BIGINT
  • post_id — BIGINT — NOT NULL
  • user_id — BIGINT
  • ip_address — VARCHAR(255)
  • viewed_at — DATETIME — NOT NULL
  • INDEX — idx_post_user
  • INDEX — idx_post_ip

users

  • id — BIGINT — Primary key
  • kakao_id — VARCHAR(128)
  • email — VARCHAR(128) — NOT NULL
  • nickname — VARCHAR(50) — NOT NULL
  • password — VARCHAR(100)
  • profile_image_url — TEXT
  • login_type — VARCHAR(30) — NOT NULL
  • is_deleted — BOOLEAN — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME