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