haegal-web

Tables (6)

books

  • book_id — CHAR(6) — Primary key — NOT NULL
  • title — VARCHAR(100) — NOT NULL
  • series — DECIMAL(3,1) — NOT NULL
  • byname1 — VARCHAR(50) — NOT NULL
  • byname2 — VARCHAR(50) — NOT NULL
  • location — CHAR(4) — NOT NULL
  • can_rent — BOOLEAN — NOT NULL

category

  • category_id — SERIAL — Primary key — NOT NULL
  • book_id — CHAR(6) — Foreign key → books.book_id — NOT NULL
  • category — VARCHAR(50) — NOT NULL
  • language — CHAR(3) — NOT NULL

fees

  • fee_id — SERIAL — Primary key — NOT NULL
  • 학번 (student_num) — CHAR(9) — Foreign key → users.학번 — NOT NULL
  • fee_type — VARCHAR(10) — NOT NULL
  • amount — NUMERIC(10,2) — NOT NULL
  • paid_date — DATE — NOT NULL

notice_board

  • notice_id — SERIAL — Primary key — NOT NULL
  • 학번 (student_num) — CHAR(9) — Foreign key → users.학번 — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • content — TEXT — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

rent

  • rent_id — SERIAL — Primary key — NOT NULL
  • book_id — CHAR(6) — Foreign key → books.book_id — NOT NULL
  • 학번 (student_num) — CHAR(9) — Foreign key → users.학번 — NOT NULL
  • rent_date — DATE — NOT NULL

users

  • 학번 (student_num) — CHAR(9) — Primary key — NOT NULL
  • 디코아이디 (discord_id) — CHAR(20)
  • name — VARCHAR(50) — NOT NULL
  • college — VARCHAR(50) — NOT NULL
  • major — VARCHAR(50) — NOT NULL
  • enroll_status — VARCHAR(10) — NOT NULL
  • note — VARCHAR(255) — NOT NULL
  • role — VARCHAR(10) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL