sidEGo

Tables (10)

Applicant (Untitled8)

  • id (Key) — Primary key — NOT NULL
  • project_id (Key2) — Foreign key → project.id — NOT NULL
  • user_id (id) — Long — Foreign key → User.id — NOT NULL
  • status (Field)
  • content (Field2)
  • career (Field3)

User (Untitled)

  • id — Long — Primary key — NOT NULL
  • username (Field)
  • password (Field2)
  • profile_img (Field3)
  • name (Field4)
  • cash (Field5)
  • profit (Field6)
  • ticket_count (Field7)
  • like (Field8)
  • email (Field9)
  • introduction (Field10)

attachment (Untitled7)

  • id (Key) — Primary key — NOT NULL
  • paper_id (Key2) — Foreign key → paper.id — NOT NULL
  • title (Field)
  • url (Field2)

cupon (Untitled6)

  • id (Key) — Primary key — NOT NULL
  • user_id (id) — Long — Foreign key → User.id — NOT NULL
  • percent (Field)
  • is_used (Field2)
  • used_at (Field3)

like (Untitled2)

  • id (Key) — Primary key — NOT NULL
  • project_id (id) — Long — Foreign key → User.id — NOT NULL
  • user_id (User_id) — Long — Foreign key → project.user_id — NOT NULL

log (Untitled9)

  • id (Key) — Primary key — NOT NULL
  • user_id (id) — Long — Foreign key → User.id — NOT NULL
  • projetct_id (Key2) — Foreign key → project.id — NOT NULL
  • type (Field)
  • status (Field2)
  • Field3

paper (Untitled4)

  • id (Key) — Primary key — NOT NULL
  • user_id (id) — Long — Foreign key → User.id — NOT NULL
  • category (Field)
  • title (Field2)
  • title_short (Field3)
  • description (Field4)
  • description_short (Field5)
  • price (Field6)

point_log (Untitled10)

  • id (Key) — Primary key — NOT NULL
  • id (user_id) — Long — Foreign key → User.id — NOT NULL
  • title (Field)
  • point (Field2)

project (Untitled3)

  • id (Key) — Primary key — NOT NULL
  • user_id (User_id) — Long — Foreign key → User.id — NOT NULL
  • category (Field)
  • title (Field2)
  • title_short (Field3)
  • member_count (Field4)
  • member_count_max (Field5)
  • date_end (Field7)
  • thumbnail (Field8)
  • body_title (Field9)
  • body_goal (Field10)
  • body_plan (Field11)
  • body_style (Field12)
  • body_requried (Field13)
  • view_count (Field15)

review (Untitled5)

  • Key — Primary key — NOT NULL
  • project_id (id) — Long — Foreign key → User.id — NOT NULL
  • user_id (User_id) — Long — Foreign key → project.user_id — NOT NULL
  • content (Field)
  • score (Field2)