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