에콩

테이블 (8)

Community (Untitled6)

  • id (Key) — bigint — 기본 키 — NOT NULL
  • comment (Field) — text
  • projectId (Key2) — bigint — 외래 키 → Projects.projectId — NOT NULL
  • userid (Key3) — bigint — 외래 키 → Users.userid — NOT NULL

Favorites (Untitled4)

  • id (Key) — bigint — 기본 키 — NOT NULL
  • userid (Key2) — bigint — 외래 키 → Users.userid — NOT NULL
  • projectId (Key3) — bigint — 외래 키 → Projects.projectId — NOT NULL

Follow (Untitled8)

  • id (Key) — bigint — 기본 키 — NOT NULL
  • followId (Key2) — bigint — 외래 키 → Users.userid — NOT NULL
  • followingId (Key3) — bigint — 외래 키 → Users.userid — NOT NULL

Orders (펀딩하기에서 주문완료 후)

  • id (Key) — bigint — 기본 키 — NOT NULL
  • donation (총 후원금) — int
  • orderStatus (Field2) — int
  • userid (Key2) — bigint — 외래 키 → Users.userid — NOT NULL
  • rewardId (Key4) — bigint — 외래 키 → Rewards.rewardId — NOT NULL
  • deliveryAddress (Field) — string
  • paymentMethod (Field3) — string
  • paymentTid (Field4) — string
  • orderName (Field5) — string

ProductImages (Untitled7)

  • id (Key) — bigint — 기본 키 — NOT NULL
  • imageUrl (Field) — text
  • projectId (Key2) — bigint — 외래 키 → Projects.projectId — NOT NULL

Projects (Untitled2)

  • projectId (Key) — bigint — 기본 키 — NOT NULL
  • title (Field) — text
  • openingDate (Field2) — datetime
  • closingDate (Field3) — datetime
  • goalAmount (Field4) — int
  • totalAmount (Field5) — int
  • summary (Field6) — text
  • status (후원중, 후원완료, 후원실패) — int
  • userid (Key2) — bigint — 외래 키 → Users.userid — NOT NULL
  • thumbnail (Field8) — text
  • acheivedRate (Field9) — demical(10,2)
  • story (Field7) — text
  • authenticate (Field10) — boolean

Rewards (Untitled3)

  • rewardId (Key) — bigint — 기본 키 — NOT NULL
  • name (Field) — varchar(255)
  • price (Field2) — int
  • stock (총 개수) — int
  • soldQuantity (팔린 개수) — int
  • combination (조합 ex) 연필 1개 볼팬 1개) — varchar(155)
  • projectId (Key2) — bigint — 외래 키 → Projects.projectId — NOT NULL

Users (Untitled)

  • userid (Key) — bigint — 기본 키 — NOT NULL
  • email (Field) — varchar(255)
  • password (Field2) — varchar(255)
  • name (Field3) — varchar(255)
  • nickName (Field4) — varchar(255)
  • description (Field5) — text
  • profileImage (Field6) — text
  • phone (Field7) — varchar(255)
  • authenticate (Field8) — boolean