advanced web programming

Tables (6)

Collections (Untitled2)

  • collectionId (Key) — PK — Primary key — NOT NULL
  • title (Field2)
  • description (Field3)
  • userId (Key2) — FK — Foreign key → Users.userId — NOT NULL

Expressions (Untitled4)

  • expressionId (Key) — PK — Primary key — NOT NULL
  • expression (Field2)
  • correctMeaningKo (Field3)
  • wrongMeaningKo (Field4)
  • exampleEn (Field5)
  • exampleKo (Field6)
  • question (Field7)
  • collectionId (Key2) — FK — Foreign key → Collections.collectionId — NOT NULL
  • isCompleted (Field)

Notifications (Untitled5)

  • notificationId (Key) — PK — Primary key — NOT NULL
  • type (Field)
  • scheduledAt (Field2)
  • sentAt (Field3)
  • status (Field4)
  • userId (Key2) — FK — Foreign key → Users.userId — NOT NULL
  • expressionId (Key3) — FK — Foreign key → Expressions.expressionId — NOT NULL

Untitled6

    UserExpressions (Untitled3)

    • userExpressionsId (Key) — PK — Primary key — NOT NULL
    • level (Field)
    • notificationsStage (Field2)
    • userId (Key2) — FK — Foreign key → Users.userId — NOT NULL
    • expressionId (Key3) — FK — Foreign key → Expressions.expressionId — NOT NULL

    Users (Untitled)

    • userId (Key) — PK — Primary key — NOT NULL
    • nickname (Field)
    • password (Field2)