nochigima2

Tables (5)

brands

  • brand_id — BIGINT
  • name — VARCHAR(100) — NOT NULL
  • logo_url — VARCHAR(500)

likes

  • like_id — BIGINT
  • user_id — BIGINT — NOT NULL
  • post_id — BIGINT — NOT NULL
  • created_at — TIMESTAMP

promotion_images

  • image_id — BIGINT
  • post_id — BIGINT — NOT NULL
  • image_url — VARCHAR(500) — NOT NULL

promotion_posts

  • post_id — BIGINT
  • title — VARCHAR(255) — NOT NULL
  • content — TEXT
  • author_id — BIGINT — NOT NULL
  • brand_id — BIGINT — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

users

  • user_id — BIGINT
  • oauth_provider — VARCHAR(50) — NOT NULL
  • oauth_id — VARCHAR(255) — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • name — VARCHAR(100)
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP