mini

Tables (14)

Activities (Untitled6)

  • Key (activities_id) — Primary key — NOT NULL
  • Key (actcategory_id) — Foreign key → activitycategory.Key — NOT NULL
  • title (Field)
  • description (Field2)
  • roomId (Field3)
  • max (Field4)
  • people (Field5)
  • d-day (Field6)

User (Untitled)

  • Key (user_id) — Text — Primary key — NOT NULL
  • email
  • password
  • phone
  • nickname
  • address (Field)

activitycategory (Untitled7)

  • Key (actcategory_id) — Primary key — NOT NULL
  • name (Field)

activitycomment (Untitled9)

  • Key — Primary key — NOT NULL
  • Key (activities_id) — Foreign key → Activities.Key — NOT NULL
  • Key (actcategory_id) — Foreign key → Activities.Key — NOT NULL
  • Key (user_id) — Text — Foreign key → User.Key — NOT NULL
  • content (Field)

activityjoin (Untitled8)

  • Key — Primary key — NOT NULL
  • Key (user_id) — Text — Foreign key → User.Key — NOT NULL
  • Key (activities_id) — Foreign key → Activities.Key — NOT NULL
  • Key (actcategory_id) — Foreign key → Activities.Key — NOT NULL
  • admiin (Field)

chat (Untitled10)

  • Key — Primary key — NOT NULL
  • Key (user_id) — Text — Foreign key → User.Key — NOT NULL
  • roomId (Field)
  • Key (user_id2) — Text — Foreign key → User.Key — NOT NULL

donation (Untitled12)

  • Key (donation_id) — Primary key — NOT NULL
  • Key (user_id) — Text — Foreign key → User.Key — NOT NULL
  • title (Field)
  • url (Field2)
  • description (Field3)
  • Field4

donationcomment (Untitled13)

  • Key — Primary key — NOT NULL
  • Key (donation_id) — Foreign key → donation.Key — NOT NULL
  • Key (user_id) — Text — Foreign key → donation.Key — NOT NULL
  • Key (user_id2) — Text — Foreign key → User.Key — NOT NULL
  • content (Field)

donationtr (Untitled14)

  • Key — Primary key — NOT NULL
  • Key (donation_id) — Foreign key → donation.Key — NOT NULL
  • Key (user_id) — Text — Foreign key → donation.Key — NOT NULL
  • Key (user_id2) — Text — Foreign key → User.Key — NOT NULL
  • impuid (Field)
  • amount (Field2)
  • status (Field3)

market (Untitled2)

  • Key (market_id) — Text — Primary key — NOT NULL
  • Key (Category_id) — Text — Foreign key → marketcategory.Key — NOT NULL
  • Key (user_id) — Text — Foreign key → User.Key — NOT NULL
  • title
  • description
  • like
  • score (Field3)
  • ascore (Field4)

marketcategory (Untitled3)

  • Key (Category_id) — Text — Primary key — NOT NULL
  • name

marketcomment (Untitled5)

  • Key (productcomment_id) — Primary key — NOT NULL
  • Key (user_id) — Text — Foreign key → User.Key — NOT NULL
  • Key (product_id) — Text — Foreign key → market.Key — NOT NULL
  • Key (Category_id) — Text — Foreign key → market.Key — NOT NULL
  • Key (user_id2) — Text — Foreign key → market.Key — NOT NULL
  • Field

marketlike (Untitled4)

  • Key (productlike_id) — Text — Primary key — NOT NULL
  • Key (product_id) — Text — Foreign key → market.Key — NOT NULL
  • Key (Category_id) — Text — Foreign key → market.Key — NOT NULL
  • Key (user_id) — Text — Foreign key → market.Key — NOT NULL
  • Key (user_id2) — Text — Foreign key → User.Key — NOT NULL
  • like — boolean

markettr (Untitled11)

  • Key — Primary key — NOT NULL
  • Key (user_id) — Text — Foreign key → User.Key — NOT NULL
  • Key (product_id) — Text — Foreign key → market.Key — NOT NULL
  • Key (Category_id) — Text — Foreign key → market.Key — NOT NULL
  • Key (user_id2) — Text — Foreign key → market.Key — NOT NULL
  • impuid (Field)
  • amount (Field2)
  • status (Field3)