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