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