NERO
Tables (11)
Clinics
- clinicId (id) — Int — Primary key — NOT NULL
- owner — ForeignKey — Foreign key → User.id — NOT NULL
- recentDay — DateTimeField
- nextDay — DateTimeField
- createdAt — DateTimeField
- updatedAt — DateTimeField
- title — CharField
DailyLogs
- id — Int — Primary key — NOT NULL
- owner — ForeignKey — Foreign key → User.id — NOT NULL
- date — DateField
- content — TextField
Drugs
- drugId (id) — Int — Primary key — NOT NULL
- item — ForeignKey — Foreign key → Clinics.clinicId — NOT NULL
- id (id2) — Int — Foreign key → Clinics.owner — NOT NULL
- status — CharField
- number — IntegerField
- time — CharField
Home
- id — Int — Primary key — NOT NULL
- owner — ForeignKey — Foreign key → User.id — NOT NULL
- title — CharField
- description — TextField
- createdAt — DateTimeField
- updatedAt — DateTimeField
Images
- id — Int — Primary key — NOT NULL
- product — ForeignKey — Foreign key → Home.owner — NOT NULL
- file — ImageField
- uploadedAt — DateTimeField
Question
- id — Int — Primary key — NOT NULL
- type — CharField
- text — CharField
SelfRecord
- id — Int — Primary key — NOT NULL
- today — ForeignKey — Foreign key → Today.id — NOT NULL
- createdAt — DateTimeField
- content — TextField
SideEffectResponse
- id — Int — Primary key — NOT NULL
- today — ForeignKey — Foreign key → Today.id — NOT NULL
- question — ForeignKey — Foreign key → Question.id — NOT NULL
- answer — CharField
SurveyResponse
- id — Int — Primary key — NOT NULL
- today — ForeignKey — Foreign key → Today.owner — NOT NULL
- question — ForeignKey — Foreign key → Question.id — NOT NULL
- answer — CharField
Today
- id — Int — Primary key — NOT NULL
- owner — ForeignKey — Foreign key → User.id — NOT NULL
- createdAt — DateTimeField
- nextAppointmentDate — DateField
User
- id — Int — Primary key — NOT NULL
- kakaoId — CharField
- nickname — CharField
- createdAt — DateTimeField
- updatedAt — DateTimeField
- email — CharField