LikeLion_Session_DB
Tables (14)
Book (Untitled11)
- id (book_id) — integer — Primary key — NOT NULL
- ISBN (isbn) — VARCHAR(255)
- title — VARCHAR(255)
- author — VARCHAR(255)
- publishing_date — DATE
Category (Untitled13)
- idc (category_id) — integer — Primary key — NOT NULL
- name — VARCHAR(255)
Class (Untitled5)
- id (class_id) — integer — Primary key — NOT NULL
- classroom — VARCHAR(255)
- year — VARCHAR(255)
- semester — VARCHAR(255)
- start_time — TIME
- end_time — TIME
- day — VARCHAR(255)
- id (course_id) — integer — Foreign key → Course.id — NOT NULL
Comment (Untitled3)
- id (comment_id) — integer — Primary key — NOT NULL
- content — VARCHAR(200)
- id (member_id) — integer — Foreign key → Member.id — NOT NULL
- id (post_id) — integer — Foreign key → Post.id — NOT NULL
Course (Untitled8)
- id (course_id) — integer — Primary key — NOT NULL
- course_number — VARCHAR(255)
- name — VARCHAR(255)
- id (professor_id) — integer — Foreign key → Professor.id — NOT NULL
Member (Untitled2)
- id (member_id) — integer — Primary key — NOT NULL
- name — VARCHAR(20)
- email — VARCHAR(255)
Post (Untitled)
- id (post_id) — integer — Primary key — NOT NULL
- title — VARCHAR(50)
- content — CHAR — NOT NULL
- create_at — TIMESTAMP
- id (member_id) — integer — Foreign key → Member.id — NOT NULL
Professor (Untitled6)
- id (professor_id) — integer — Primary key — NOT NULL
- professor_number — VARCHAR(255)
- name — VARCHAR(255)
- gender — VARCHAR(10)
Register (Untitled9)
- id (register_id) — integer — Primary key — NOT NULL
- id (student_id) — integer — Foreign key → Student.id — NOT NULL
- score — VARCHAR(10)
- id (class_id) — integer — Foreign key → Class.id — NOT NULL
Rental (Untitled12)
- id (rental_id) — integer — Primary key — NOT NULL
- late_check — boolean
- late_fee — integer
- rental_date — DATE
- due_date — DATE
- return_check — boolean
- id (user_id) — integer — Foreign key → User.id — NOT NULL
- id (book_id) — integer — Foreign key → Book.id — NOT NULL
Student (Untitled7)
- id (student_id) — integer — Primary key — NOT NULL
- student_number — VARCHAR(255)
- name — VARCHAR(255)
- address — VARCHAR(255)
User (Untitled10)
- id (user_id) — integer — Primary key — NOT NULL
- name — VARCHAR(255)
- late_check — boolean
UserPost (Untitled4)
- id (user_post_id) — integer — Primary key — NOT NULL
- id (member_id) — integer — Foreign key → Member.id — NOT NULL
- id (post_id) — integer — Foreign key → Post.id — NOT NULL
relation (Untitled14)
- id (relation_id) — integer — Primary key — NOT NULL
- id (book_id) — integer — Foreign key → Book.id — NOT NULL
- idc (category_id) — integer — Foreign key → Category.idc — NOT NULL