ASSA_V2
Tables (5)
likes
- id — BIGINT — Primary key — NOT NULL
- Key (user_id) — BIGINT — Foreign key → users.Key — NOT NULL
- likeable_id — BIGINT — NOT NULL
- likeable_type — VARCHAR(255) — NOT NULL
- created_at — TIMESTAMP
post_images
- id — BIGINT — Primary key — NOT NULL
- id (post_id) — BIGINT — Foreign key → posts.id — NOT NULL
- image_url — VARCHAR(2048) — NOT NULL
- display_order — TINYINT — NOT NULL
- created_at — TIMESTAMP
posts
- id — BIGINT — Primary key — NOT NULL
- Key (user_id) — BIGINT — Foreign key → users.Key — NOT NULL
- content — TEXT
- view_count — INT — NOT NULL
- like_count — INT — NOT NULL
- comment_count — INT — NOT NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
social_accounts
- Key (id) — BIGINT — Primary key — NOT NULL
- Key (user_id) — BIGINT — Foreign key → users.Key — NOT NULL
- provider_name — VARCHAR(50) — NOT NULL
- provider_id — VARCHAR(255) — NOT NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
users
- Key (id) — BIGINT — Primary key — NOT NULL
- email — VARCHAR(255) — NOT NULL
- password — VARCHAR(255)
- name — VARCHAR(50) — NOT NULL
- introduction — TEXT
- profile_image_url — VARCHAR(2048)
- created_at — TIMESTAMP
- updated_at — TIMESTAMP