AppProgramming

Tables (4)

Comment (Untitled)

  • id — NOTNULL — Primary key — NOT NULL
  • userId (id2) — NOTNULL — Foreign key → User.id — NOT NULL
  • postId (게시물 ID) — NOTNULL
  • postType (게시물 형태) — NOTNULL
  • content (댓글) — NOTNULL

Find (찾아가세요)

  • id — NOTNULL — Primary key — NOT NULL
  • userId (유저 ID) — NOTNULL — Foreign key → User.id — NOT NULL
  • title (물품명) — NOTNULL
  • place (습득장소) — NOTNULL
  • placeDetail (상세 습득장소) — NOTNULL
  • day (습득일자) — NOTNULL
  • detail (세부사항) — NOTNULL
  • imagePath (사진) — NOTNULL

Missing (분실물)

  • id — NOTNULL — Primary key — NOT NULL
  • userId (유저 ID) — NOTNULL — Foreign key → User.id — NOT NULL
  • title (물품명) — NOTNULL
  • place (습득장소) — NOTNULL
  • placeDetail (상세 습득장소) — NOTNULL
  • day (습득일자) — NOTNULL
  • detail (세부사항) — NOTNULL
  • imagePath (사진) — NOTNULL

User (유저)

  • id — NOTNULL — Primary key — NOT NULL
  • email (이메일) — NOTNULL
  • password (비밀번호) — NOTNULL