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