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