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