TimeTable Maker_ERD
Tables (5)
lecture
- id — BIGSERIAL — Primary key
- year — INT — NOT NULL
- semester — INT — NOT NULL
- code — VARCHAR(32)
- name — VARCHAR(200) — NOT NULL
- professor — VARCHAR(100)
- day — VARCHAR(5)
- period — INT
- classroom — VARCHAR(100)
- ge_category — VARCHAR(50)
- credit — INT — NOT NULL
timetable
- id — BIGSERIAL — Primary key
- id (id2) — BIGSERIAL — Foreign key → users.id
- user_id — BIGINT — NOT NULL
- year — INT — NOT NULL
- semester — INT — NOT NULL
- total_credits — INT
- created_at — TIMESTAMP
timetable_item
- id — BIGSERIAL — Primary key
- id (id2) — BIGSERIAL — Foreign key → timetable.id
- id (id22) — BIGSERIAL — Foreign key → timetable.id
- timetable_id — BIGINT — NOT NULL
- lecture_id — BIGINT
- user_lecture_id — BIGINT
- day — VARCHAR(5)
- period — INT
- is_fixed — BOOLEAN
- CHECK — ( (lecture_id IS NOT NULL AND user_lecture_id IS NULL) — NOT NULL
user_lecture
- id — BIGSERIAL — Primary key
- id (id2) — BIGSERIAL — Foreign key → users.id
- user_id — BIGINT — NOT NULL
- name — VARCHAR(200) — NOT NULL
- day — VARCHAR(5)
- period — INT
- classroom — VARCHAR(100)
- credit — INT — NOT NULL
- created_at — TIMESTAMP
users
- id — BIGSERIAL — Primary key
- student_id — VARCHAR(64) — NOT NULL
- name — VARCHAR(100) — NOT NULL
- major — VARCHAR(100) — NOT NULL
- email — VARCHAR(120) — NOT NULL
- password — VARCHAR(200) — NOT NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP