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)