FoodStargram nosql

Tables (8)

File (Untitled4)

  • _id (Key) — Primary key — NOT NULL
  • filepath (Field)
  • filesize (Field2)
  • realfilepath (Field3)
  • filename (Field4)
  • extention (Field5)
  • size (Field6)

HomePage (Untitled3)

  • id (Key) — Primary key — NOT NULL
  • u_id (id2) — Foreign key → User._id — NOT NULL
  • addr (Field2)
  • memo (Field3)
  • pushyn (Field4)
  • postview (Field5)
  • regdate (Field6)
  • uesyn (Field7)
  • pvcnt (Field8)
  • msgboxId (m_id)
  • latitude (Field)
  • longitude (Field9)

User (Untitled)

  • _id (id) — Primary key — NOT NULL
  • email
  • hpno
  • nickname
  • password
  • cate
  • follower — array
  • following — array
  • regdate
  • p_id

comment (Untitled6)

  • _id (Key) — Primary key — NOT NULL
  • p_id (Key2) — Foreign key → post._id — NOT NULL
  • regId (Field)
  • parentId (Field2)
  • likeCnt (Field3)
  • comment (Field4)
  • regdate (Field5)
  • useyn (Field6)

msgBox (CopyOfUntitled6)

  • _id (Key) — Primary key — NOT NULL
  • u_id (id2) — Foreign key → HomePage.u_id — NOT NULL
  • regId (Field)
  • likeCnt (Field3)
  • comment (Field4)
  • regdate (Field5)
  • useyn (Field6)

post (Untitled2)

  • _id (Key) — Primary key — NOT NULL
  • h_id (Key2) — Foreign key → HomePage.id — NOT NULL
  • content (Field)
  • regid (Field2)
  • heartcnt (Field3)
  • likeCnt (Field4)
  • tag_id (Key3) — array — Foreign key → tag._id — NOT NULL
  • thumb_id (Key4) — object — Foreign key → File._id — NOT NULL

postFile (Untitled5)

  • _id (Key) — Primary key — NOT NULL
  • p_id (Key2) — Foreign key → post._id — NOT NULL
  • useyn (Field3)
  • regDate (Field4)
  • f_id (Key3) — array — Foreign key → File._id — NOT NULL

tag (Untitled7)

  • _id (Key) — Primary key — NOT NULL
  • tagname (Field)
  • regdate (Field2)