likelion_week5

Tables (15)

Book (Untitled12)

  • id (book_id) — Primary key — NOT NULL
  • ISBN
  • title
  • author
  • year

Category (Untitled13)

  • id (category_id) — Primary key — NOT NULL
  • name
  • id (book_id) — Foreign key → Book.id — NOT NULL

Comment (Untitled3)

  • id (comment_id) — int — Primary key — NOT NULL
  • content — varchar(200)
  • id (post_id) — int — Foreign key → Post.id — NOT NULL
  • id (member_id) — int — Foreign key → Member.id — NOT NULL
  • Field

Course (Untitled7)

  • id (course_id) — Primary key — NOT NULL
  • name (course_name)

Instructor (Untitled6)

  • id (instructor_id) — Primary key — NOT NULL
  • name
  • age
  • gender

LateFee (Untitled15)

  • id (latefee_id) — Primary key — NOT NULL
  • days
  • amount
  • id (user_id) — Foreign key → User.id — NOT NULL
  • id (rent_id) — Foreign key → Rent.id — NOT NULL

Lecture (Untitled8)

  • id (lecture_id) — Primary key — NOT NULL
  • id (instructor_id) — Foreign key → Instructor.id — NOT NULL
  • id (takes_id) — Foreign key → Takes.id — NOT NULL
  • id (course_id) — Foreign key → Course.id — NOT NULL

Member (Untitled2)

  • id (member_id) — int — Primary key — NOT NULL
  • name — varchar(20)
  • email — varchar(100)

Post (Untitled)

  • id (post_id) — int — Primary key — NOT NULL
  • title — varchar(50)
  • content — text
  • create_at — timestamp
  • id (member_id) — int — Foreign key → Member.id — NOT NULL

Rent (Untitled14)

  • id (rent_id) — Primary key — NOT NULL
  • rent_date
  • return_date
  • id (user_id) — Foreign key → User.id — NOT NULL
  • id (book_id) — Foreign key → Book.id — NOT NULL

Student (Untitled5)

  • id (student_id) — Primary key — NOT NULL
  • name
  • address

Takes (Untitled10)

  • id (takes_id) — Primary key — NOT NULL
  • grade
  • id (student_id) — Foreign key → Student.id — NOT NULL

TimeSlot (Untitled9)

  • id (time_slot_id) — Primary key — NOT NULL
  • day
  • start_time
  • end_time
  • id (lecture_id) — Foreign key → Lecture.id — NOT NULL

User (Untitled11)

  • id (user_id) — Primary key — NOT NULL
  • name
  • password

UserPost (Untitled4)

  • id (post_id) — int — Foreign key → Post.id — NOT NULL
  • id (member_id) — int — Foreign key → Member.id — NOT NULL