쉽고펀딩 ERD
테이블 (9)
banners (Untitled6)
- id (Key) — int — 기본 키 — NOT NULL
- funding_id (Key2) — int — 외래 키 → fundings.id — NOT NULL
- image (Field) — string — NOT NULL
- created_at (Field2) — datetime — NOT NULL
- modified_at (Field3) — datetime
- deleted_at (Field4) — datetime
- is_deleted (Field5) — boolean — NOT NULL
comments (Untitled4)
- id (Key) — int — 기본 키 — NOT NULL
- user_id (Key2) — int — 외래 키 → users.id — NOT NULL
- funding_id (Key3) — int — 외래 키 → fundings.id — NOT NULL
- content (Field) — string — NOT NULL
- created_at (Field2) — datetime — NOT NULL
- modified_at (Field3) — datetime
- deleted_at (Field4) — datetime
- is_deleted (Field5) — boolean — NOT NULL
funding_hearts (Untitled5)
- id (Key) — int — 기본 키 — NOT NULL
- user_id (Key2) — int — 외래 키 → users.id — NOT NULL
- funding_id (Key3) — int — 외래 키 → fundings.id — NOT NULL
- created_at (Field) — datetime — NOT NULL
- modified_at (Field2) — datetime
- deleted_at (Field3) — datetime
- is_deleted (Field4) — boolean — NOT NULL
funding_histories (CopyOfUntitled5)
- id (Key) — int — 기본 키 — NOT NULL
- user_id (Key2) — int — 외래 키 → users.id — NOT NULL
- funding_id (Key3) — int — 외래 키 → fundings.id — NOT NULL
- created_at (Field) — datetime — NOT NULL
- modified_at (Field2) — datetime
- deleted_at (Field3) — datetime
- is_deleted (Field4) — boolean — NOT NULL
funding_images (Untitled7)
- id (Key) — int — 기본 키 — NOT NULL
- funding_id (Key2) — int — 외래 키 → fundings.id — NOT NULL
- funding_image (Field) — string — NOT NULL
- created_at (Field2) — datetime — NOT NULL
- modified_at (Field3) — datetime
- deleted_at (Field4) — datetime
- is_deleted (Field5) — boolean — NOT NULL
fundings (Untitled2)
- id (Key) — int — 기본 키 — NOT NULL
- user_id (Key2) — int — 외래 키 → users.id — NOT NULL
- funding_title (Field) — string — NOT NULL
- funding_summary (Field2) — string — NOT NULL
- funding_description (Field3) — string — NOT NULL
- category (Field10) — string — NOT NULL
- individual_price (Field13) — int — NOT NULL
- total_price (Field4) — int — NOT NULL
- start_date (Field11) — datetime — NOT NULL
- end_date (Field12) — datetime — NOT NULL
- state (Field5) — enum — NOT NULL
- created_at (Field6) — datetime — NOT NULL
- modified_at (Field7) — datetime
- deleted_at (Field8) — datetime
- is_deleted (Field9) — boolean — NOT NULL
notification_fundings (CopyOfUntitled52)
- id (Key) — int — 기본 키 — NOT NULL
- user_id (Key2) — int — 외래 키 → users.id — NOT NULL
- funding_id (Key3) — int — 외래 키 → fundings.id — NOT NULL
- created_at (Field) — datetime — NOT NULL
- modified_at (Field2) — datetime
- deleted_at (Field3) — datetime
- is_deleted (Field4) — boolean — NOT NULL
participating_fundings (Untitled3)
- id (Key) — int — 기본 키 — NOT NULL
- user_id (Key2) — int — 외래 키 → users.id — NOT NULL
- funding_id (Key3) — int — 외래 키 → fundings.id — NOT NULL
- created_at (Field) — datetime — NOT NULL
- modified_at (Field2) — datetime
- deleted_at (Field3) — datetime
- is_deleted (Field4) — boolean — NOT NULL
users (Untitled)
- id (Key) — int — 기본 키 — NOT NULL
- email (Field) — string — NOT NULL
- password (Field2) — string — NOT NULL
- image (Field8) — string
- nickname (Field3) — string — NOT NULL
- role (Field9) — enum
- created_at (Field4) — datetime — NOT NULL
- modified_at (Field5) — datetime
- deleted_at (Field6) — datetime
- is_deleted (Field7) — boolean — NOT NULL