food-defect

Tables (5)

apartments (Untitled)

  • apartmentId (pk) — bigint — Primary key — NOT NULL
  • apartmentName (Field)
  • dong (Field2)
  • ho (Field3)

foodApplications (Untitled3)

  • faId (pk) — bigint — Primary key — NOT NULL
  • userId (fk) — bigint — Foreign key → users.userId — NOT NULL
  • who (enum) — enum
  • agree (Field)
  • alert (Field2)

submitQuestions (Untitled5)

  • sqId (Key) — Primary key — NOT NULL
  • submitId (Key2) — Foreign key → submits.submitId — NOT NULL
  • context (json)
  • etc (Field2)

submits (Untitled4)

  • submitId (Key) — Primary key — NOT NULL
  • faId (pk) — bigint — Foreign key → foodApplications.faId — NOT NULL
  • questionNo (enum) — 1,2,3,4
  • questionAnswer (Field)
  • sqId (Key2) — Foreign key → submitQuestions.sqId — NOT NULL

users (Untitled2)

  • userId (Key) — bigint — Primary key — NOT NULL
  • apartmentId (fk) — bigint — Foreign key → apartments.apartmentId — NOT NULL
  • joinId (Field)
  • name (Field2)
  • Field3