멋사1

테이블 (15)

Book (book)

  • book_ISBN (book_isbn) — int — 기본 키 — NOT NULL
  • book_name — string
  • book_author — string
  • book_year_of_publication — int

Book_Category (book_category)

  • bookcategory_id — int — 기본 키 — NOT NULL
  • book_ISBN (book_isbn) — int — 외래 키 → Book.book_ISBN — NOT NULL
  • category_num (category_num2) — int — 외래 키 → Category.category_num — NOT NULL

Category (category)

  • category_num — int — 기본 키 — NOT NULL
  • category_name — string

Content (content)

  • con_id (content_id) — string — 기본 키
  • content (con_content) — string
  • mem_id (member_id) — char — 외래 키 → Member.mem_id — NOT NULL
  • id (post_id) — char — 외래 키 → Post.id — NOT NULL

Course (course)

  • course_num — float — 기본 키 — NOT NULL
  • course_location — string
  • course_day_of_week — string
  • course_time — string
  • lecturer_num — float — 외래 키 → Lecturer.lecturer_num — NOT NULL
  • Key — 외래 키 → Lecturer.Key — NOT NULL
  • subject_num — float — 외래 키 → Subject.subject_num — NOT NULL

Enrollment (enrollment)

  • enrollment_id — int — 기본 키 — NOT NULL
  • student_grade — float
  • course_num — float — 외래 키 → Course.course_num — NOT NULL
  • student_id — float — 외래 키 → Student.student_id — NOT NULL

Lecturer (lecturer)

  • lecturer_num — float — 기본 키 — NOT NULL
  • Key — 기본 키 — NOT NULL
  • lecturer_name — string
  • lecturer_age — int
  • lecturer_sex — char

Member (member)

  • mem_id (member_id) — char — 기본 키 — NOT NULL
  • email (member_email) — char
  • name (member_name) — char

Overdue_log (overdue_log)

  • overdue_log_id — int — 기본 키 — NOT NULL
  • overdue_fee — float
  • over_date — int
  • paid_status — boolean
  • paid_date — int — NOT NULL

Post (post)

  • id (post_id) — char — 기본 키 — NOT NULL
  • title (post_title) — string
  • content (post_content) — string — NOT NULL
  • create_at (post_create_at) — float
  • mem_id (member_id) — char — 외래 키 → Member.mem_id — NOT NULL

Rental_Informatnion (rental_information)

  • rental_id — int — 기본 키 — NOT NULL
  • rental_date — int
  • return_due_date — int
  • user_id — string — 외래 키 → User.user_id — NOT NULL
  • book_ISBN (book_isbn) — int — 외래 키 → Book.book_ISBN — NOT NULL
  • overdue_log_id — int — 외래 키 → Overdue_log.overdue_log_id — NOT NULL

Student (student)

  • student_id — float — 기본 키 — NOT NULL
  • student_name — string
  • student_address

Subject (subject)

  • subject_num — float — 기본 키 — NOT NULL
  • subject_name — string

User (user)

  • user_id — string — 기본 키 — NOT NULL
  • user_password — string

UserPost (userpost)

  • userpost_id (id) — 기본 키 — NOT NULL
  • id (post_id) — char — 외래 키 → Post.id — NOT NULL
  • mem_id (member_id) — char — 외래 키 → Member.mem_id — NOT NULL