qmeet_chemi

Tables (12)

banner (Untitled10)

  • userid (Key) — INTEGER — Foreign key → mento banner.userid — NOT NULL
  • images (Field) — JSON
  • createdAt (Field2) — DATE

comments (Untitled8)

  • commentId (Key) — INTEGER — Primary key — NOT NULL
  • id (Key3) — INTEGER — Foreign key → post.userid — NOT NULL
  • writer (Field3) — STRING
  • contents (Field) — STRING
  • createdAt (Field2) — DATE
  • upDatedAt (Field4) — DATE

feedback (Untitled12)

  • mentoringid (Key2) — INTEGER — Foreign key → reservation.mentoringid — NOT NULL
  • userid (Key) — INTEGER — Foreign key → reservation.userid — NOT NULL
  • feeling (Field) — STRING
  • images (Field2) — JSON
  • contents (Field3) — STRING
  • feedbackdesc (Field4) — JSON
  • createdAt (Field5) — DATE

folder (Untitled3)

  • id (Key2) — INTEGER — Primary key — NOT NULL
  • userid (Key) — INTEGER — Foreign key → user.id — NOT NULL
  • name (Field) — STRING
  • list (Field2) — STRING

mento banner (Untitled7)

  • userid (Key) — INTEGER — Foreign key → profile.userid — NOT NULL
  • image (Field) — STRING
  • keyword (Field2) — JSON
  • createdAt (Field3) — DATE
  • updatedAt (Field4) — DATE

portfolio (Untitled4)

  • id (Key) — INTEGER — Primary key — NOT NULL
  • folderid (Key2) — INTEGER — Foreign key → folder.id — NOT NULL
  • image (Field) — JSON
  • title (Field2) — STRING
  • contents (Field3) — STRING
  • hashtag (Field4) — JSON

post (Untitled5)

  • id (Key) — INTEGER — Primary key — NOT NULL
  • userid (Key3) — INTEGER — Foreign key → profile.userid — NOT NULL
  • images (Field) — JSON
  • type (Field2) — STRING
  • writer (Field3) — STRING
  • title (Field4) — STRING
  • contents (Field5) — STRING
  • hashtag (Field6) — JSON
  • comments (Field7) — JSON
  • liked (Field8) — JSON

profile (Untitled2)

  • id (Key2) — INTEGER — Primary key — NOT NULL
  • userid (Key) — INTEGER — Foreign key → user.id — NOT NULL
  • follower (Field2) — JSON
  • follow (Field3) — JSON
  • avatar (Field4) — STRING
  • intro (Field5) — STRING
  • career (Field6) — JSON
  • subject (Field7) — JSON
  • interest (Field8) — JSON
  • cash (Field9) — INTEGER
  • createdAt (Field) — DATE
  • updatedAt (Field10) — DATE
  • searchkey (Field11) — JSON

recomment (Untitled9)

  • id (Key) — Primary key — NOT NULL
  • commentId (Key3) — INTEGER — Foreign key → comments.id — NOT NULL
  • writer (Field) — STRING
  • contents (Field2) — STRING
  • createdAt (Field3) — DATE
  • upDatedAt (Field4) — DATE

reservation (Untitled11)

  • mentoringid (Key2) — INTEGER — Primary key — NOT NULL
  • userid (Key) — INTEGER — Foreign key → banner.userid — NOT NULL
  • mentorid (Field) — INTEGER
  • mentiid (Field2) — INTEGER
  • contents (Field3) — STRING
  • status (Field6) — BOOLEAN
  • time (Field4) — DATE
  • createdAt (Field5) — DATE

user (Untitled)

  • id (Key) — INTEGER — Primary key — NOT NULL
  • authtype (Field8) — STRING
  • nickname (Field2) — STRING
  • email (Field4) — STRING
  • password (Field3) — STRING
  • salt (Field5) — STRING
  • isMento (Field) — BOOLEAN
  • isOnline (Field9) — BOOLEAN
  • createdAt (Field6) — DATE
  • upadatedAt (Field7) — DATE

vote (Untitled6)

  • voteid (Key2) — INTEGER — Primary key — NOT NULL
  • userid (Key3) — INTEGER — Foreign key → post.userid — NOT NULL
  • title (Field2) — STRING
  • selection (Field3) — JSON
  • Field