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