Ignore:
Timestamp:
09/16/26 14:48:55 (7 days ago)
Author:
Stefan-Saveski <stefansaveski19@…>
Branches:
master
Children:
f7c8acf
Parents:
1b20b22
Message:

Refactor payment model to remove redundant user_id, addressing BCNF violation in Phase 5 normalization

File:
1 edited

Legend:

Unmodified
Added
Removed

  • sql/schema_creation.sql

    r1b20b22 r20df1a3  
    115115CREATE TABLE payment (
    116116    id             INTEGER PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY,
    117     user_id        INTEGER NOT NULL REFERENCES users (id),
    118117    enrollment_id  INTEGER NOT NULL REFERENCES enrolled_semesters (id),
    119118    amount         INTEGER NOT NULL
Note: See TracChangeset for help on using the changeset viewer.