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)