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