Pumassi
Tables (5)
Asset
- id — String — Primary key — NOT NULL
- url — String
- postId — String — Foreign key → Post.id — NOT NULL
- createdAt — Timestamp
- deletedAt — Timestamp
Message
- id — Stirng — Primary key — NOT NULL
- message — String
- roomId — String — Foreign key → Room.id — NOT NULL
- writerId — String — Foreign key → User.id — NOT NULL
- createdAt — Timestamp
- deletedAt — Timestmap
Post
- id — String — Primary key — NOT NULL
- title — String
- content — String
- reward — String
- host — String — Foreign key → User.id — NOT NULL
- createdAt — Timestamp
- updatedAt — Timestamp
- deletedAt — Timestamp
Room
- id — String — Primary key — NOT NULL
- createdAt — Timestamp
- deletedAt — Timestamp
- member — String — Foreign key → User.id — NOT NULL
User
- id — String — Primary key — NOT NULL
- email — String
- name — String
- password — String
- entranceYear — Number
- grade — Number
- createdAt — Timestamp
- updatedAt — Timestamp
- deletedAt — Timestamp