쉽고펀딩 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