멋사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