inssider - base
Tables (11)
accounts
- id — bigint — Primary key — NOT NULL
- email — varchar(255)
- password — varchar(255)
- provider_user_id — varchar(255)
- account_type — varchar(255)
- role — varchar(255)
- created_at — timestamp(6) — NOT NULL
- updated_at — timestamp(6)
- deleted_at — timestamp(6)
- is_deleted — boolean — NOT NULL
authorization_codes
- id — varchar(36) — Primary key — NOT NULL
- email — varchar(255)
- created_at — timestamp(6)
- expired_at — timestamp(6)
categories
- id — bigint — Primary key — NOT NULL
- type — varchar(255) — NOT NULL
comments
- id — bigint — Primary key — NOT NULL
- content — varchar(255)
- post_id — bigint — NOT NULL
- parent_comment_id — bigint
- created_at — timestamp(6)
- updated_at — timestamp(6)
- deleted_at — timestamp(6)
- is_deleted — boolean — NOT NULL
- id2 — bigint — Foreign key → accounts.id — NOT NULL
email_verification_codes
- email — varchar(255) — Primary key — NOT NULL
- code — varchar(255) — NOT NULL
- created_at — timestamp(6) — NOT NULL
- expired_at — timestamp(6)
likes
- Key — bigint — Primary key — NOT NULL
- target_id — bigint
- target_type — varchar(255) — NOT NULL
- created_at — timestamp(6)
- id2 — bigint — Foreign key → accounts.id — NOT NULL
post_tags
- id — bigint — Primary key — NOT NULL
- id2 — bigint — Foreign key → posts.id — NOT NULL
- id3 — bigint — Foreign key → tags.id — NOT NULL
posts
- id — bigint — Primary key — NOT NULL
- title — varchar(255) — NOT NULL
- content — varchar(255)
- media_url — TEXT — NOT NULL
- media_upload_time — timestamp(6) — NOT NULL
- created_at — timestamp(6)
- updated_at — timestamp(6)
- deleted_at — timestamp(6)
- is_deleted — boolean — NOT NULL
- id2 — bigint — Foreign key → accounts.id — NOT NULL
- id3 — bigint — Foreign key → categories.id — NOT NULL
refresh_tokens
- id1 — bigint — Foreign key → accounts.id — NOT NULL
- token — varchar(1000)
tags
- id — bigint — Primary key — NOT NULL
- name — varchar(255) — NOT NULL
- created_at — timestamp(6)
user_profiles
- id2 — bigint — Foreign key → accounts.id — NOT NULL
- nickname — varchar(255)
- bio — varchar(255)
- profile_url — varchar(255)
- account_visible — boolean — NOT NULL
- follower_visible — boolean — NOT NULL
- created_at — timestamp(6) — NOT NULL
- updated_at — timestamp(6)
- deleted_at — timestamp(6)
- is_deleted — boolean — NOT NULL