playbook0.2.0
made 2025.05.14
Tables (7)
tb_admin
- seq_admin — INT — Primary key — NOT NULL
- id_admin — VARCHAR(30)
- pw_admin — VARCHAR(255)
- name_admin — VARCHAR(20)
- dc_admin — VARCHAR(30)
- status_admin — ENUM('0', '1')
tb_book
- seq_book — INT — Primary key — NOT NULL
- seq_sort_first — INT — Foreign key → tb_sort_first.seq_sort_first — NOT NULL
- seq_sort_second — INT — Foreign key → tb_sort_second.seq_sort_second — NOT NULL
- isbn_book — VARCHAR(20)
- author_book — VARCHAR(20)
- publish_book — VARCHAR(20)
- pdate_book — DATETIME
- barcode_book — VARCHAR(30)
- cnt_book — INT
- title_book — VARCHAR(100)
tb_course
- seq_course — INT — Primary key — NOT NULL
- name_course — VARCHAR(30)
- start_dt_course — DATETIME
- finish_dt_course — DATETIME
tb_history
- seq_history — BIGINT — Primary key — NOT NULL
- seq_admin — INT — Foreign key → tb_admin.seq_admin — NOT NULL
- seq_user — INT — Foreign key → tb_user.seq_user — NOT NULL
- seq_course — INT — Foreign key → tb_course.seq_course — NOT NULL
- seq_book — INT — Foreign key → tb_book.seq_book — NOT NULL
- book_dt — DATETIME
- return_dt — DATETIME
tb_sort_first
- seq_sort_first — INT — Primary key — NOT NULL
- name_sort_first — VARCHAR(20)
tb_sort_second
- seq_sort_second — INT — Primary key — NOT NULL
- seq_sort_first — INT — Foreign key → tb_sort_first.seq_sort_first — NOT NULL
- name_sort_second — VARCHAR(20)
tb_user
- seq_user — INT — Primary key — NOT NULL
- seq_course — INT — Foreign key → tb_course.seq_course — NOT NULL
- id_user — VARCHAR(30) — NOT NULL
- pw_user — VARCHAR(255)
- name_user — VARCHAR(20)
- dc_user — VARCHAR(30)
- agree_terms_user — TINYINT(1)
- agree_info_user — TINYINT(1)
- status_user — ENUM('0', '1', '2')