Dr.Trash

Tables (10)

achievement (Untitled5)

  • id (Key) — SERIAL — Primary key — NOT NULL
  • name (Field)
  • description (Field2)
  • imageUri (Field3)

achiever (Untitled6)

  • userId (Key) — SERIAL — Foreign key → user.id — NOT NULL
  • achievementId (Key2) — SERIAL — Foreign key → achievement.id — NOT NULL
  • achievedAt (Field)

article (Untitled3)

  • id (Key) — SERIAL — Primary key — NOT NULL
  • author_id (Key2) — SERIAL — Foreign key → user.id — NOT NULL
  • title (Field)
  • content (Field2)
  • likeCount (Field7)
  • viewCount (Field3)
  • hateCount (Field8)
  • createdAt (Field5)
  • updatedAt (Field6)

comment (Untitled4)

  • id (Key) — SERIAL — Primary key — NOT NULL
  • authorId (Key2) — SERIAL — Foreign key → user.id — NOT NULL
  • articleId (Key3) — SERIAL — Foreign key → article.id — NOT NULL
  • content (Field)
  • createdAt (Field2)
  • updatedAt (Field3)
  • likeCount (Field4)
  • hateCount (Field5)

token (Untitled7)

  • id (Key) — Primary key — NOT NULL
  • createdAt (Field) — NOT NULL

trash (Untitled9)

  • id (Key) — SERIAL — Primary key — NOT NULL
  • usageId (Key2) — SERIAL — Foreign key → trashcanUsage.id — NOT NULL
  • type (Field2) — VARCHAR(32) — NOT NULL
  • at (Field3) — TIMESTAMP — NOT NULL

trashcan (Untitled2)

  • id (Key) — SERIAL — Primary key — NOT NULL
  • code (Key3) — CHAR(32) — Foreign key → trashcanCode.code — NOT NULL
  • managerId (Key2) — SERIAL — Foreign key → user.id
  • name (Field)
  • type (Field7)
  • phoneNumber (Field2)
  • latitude (Field3)
  • longitude (Field4)
  • createdAt (Field5)
  • updatedAt (Field6)

trashcanCode (Untitled8)

  • code (Key) — CHAR(32) — Primary key — NOT NULL
  • createdAt (Field) — TIMESTAMP — NOT NULL

trashcanUsage (Untitled10)

  • id (Key) — SERIAL — Primary key — NOT NULL
  • userId (Key2) — SERIAL — Foreign key → user.id — NOT NULL
  • trashcanIdid (Key3) — SERIAL — Foreign key → trashcan.id — NOT NULL
  • beginAt (Field2) — TIMESTAMP — NOT NULL
  • endAt (Field) — TIMESTAMP — NOT NULL

user (Untitled)

  • id (Key) — SERIAL — Primary key — NOT NULL
  • kakaoId (Field4)
  • name (Field2)
  • thumbnail (Field)
  • point (Field3)