졸작야호
테이블 (7)
categories
- id — BIGSERIAL
- category — VARCHAR(20) — NOT NULL
levels
- id — BIGSERIAL — NOT NULL
- name — VARCHAR(50) — NOT NULL
- min_score — INT
- max_score — INT
- description — TEXT
qna_comments
- id — BIGSERIAL
- recycling_id — BIGINT — 외래 키 → recycling_posts.id — NOT NULL
- user_id — BIGINT — 외래 키 → users.id — NOT NULL
- parent_id — BIGINT — 외래 키 → qna_comments.id
- content — TEXT — NOT NULL
- created_at — timestamptz — NOT NULL
- updated_at — timestamptz
recycling_images
- id — BIGSERIAL
- recycling_id — BIGINT — 외래 키 → recycling_posts.id — NOT NULL
- image_url — VARCHAR(255) — NOT NULL
- created_at — timestamptz — NOT NULL
- updated_at — timestamptz
recycling_posts
- id — BIGSERIAL
- user_id — BIGINT — 외래 키 → users.id — NOT NULL
- title — VARCHAR(255) — NOT NULL
- description — TEXT — NOT NULL
- created_at — timestamptz — NOT NULL
- updated_at — timestamptz
- thumb_nail_image — VARCHAR(255) — NOT NULL
- category_id — BIGINT — 외래 키 → categories.id — NOT NULL
scraps
- id — BIGSERIAL
- recycling_id — BIGINT — 외래 키 → recycling_posts.id — NOT NULL
- user_id — BIGINT — 외래 키 → users.id — NOT NULL
- created_at — timestamptz — NOT NULL
users
- id — BIGSERIAL
- login_id — VARCHAR(50) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- name — VARCHAR(100) — NOT NULL
- role — VARCHAR(20) — NOT NULL
- USER)) — DEFAULT
- birth — DATE
- region — VARCHAR(100)
- profile_url — VARCHAR(255)
- follower_count — BIGINT — NOT NULL
- following_count — BIGINT — NOT NULL