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
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)