playbook-real
Tables (8)
tb_admin
- seq_admin — INT — Primary key — NOT NULL
- id_admin — VARCHAR(30) — NOT NULL
- pw_admin — VARCHAR(255) — NOT NULL
- name_admin — VARCHAR(20) — NOT NULL
- dc_admin — VARCHAR(30) — NOT NULL
- agree_terms_admin — TINYINT(1) — NOT NULL
- agree_info_admin — TINYINT(1) — NOT NULL
- agree_discord_alarm_admin — TINYINT(1) — NOT NULL
- status_admin — ENUM('stop', 'available', 'overdue') — NOT NULL — stop:정지, available:대여, overdue:연체' NOT NUL
- created_at — DATE — NOT NULL
tb_book
- seq_book — INT — Primary key — NOT NULL
- seq_sort_second — INT — Foreign key → tb_sort_second.seq_sort_second — NOT NULL
- isbn_book — VARCHAR(20) — NOT NULL
- title_book — VARCHAR(255) — NOT NULL
- author_book — VARCHAR(20) — NOT NULL
- publisher_book — VARCHAR(20) — NOT NULL
- publish_date_book — DATE — NOT NULL
- img_url_book — VARCHAR(255) — NOT NULL
- barcode_book — VARCHAR(30)
- cnt_book — INT
- print_check_book — TINYINT(1) — NOT NULL
- is_book_borrowed — TINYINT(1) — NOT NULL
tb_course
- seq_course — INT — Primary key — NOT NULL
- name_course — VARCHAR(30) — NOT NULL
- start_dt_course — DATE — NOT NULL
- finish_dt_course — DATE — NOT NULL
tb_favor
- seq_favor — INT — Primary key — NOT NULL
- seq_user — INT — Foreign key → tb_user.seq_user — NOT NULL
- seq_book — INT — Foreign key → tb_book.seq_book — NOT NULL
tb_history
- seq_history — INT — Primary key — NOT NULL
- seq_admin — INT — Foreign key → tb_admin.seq_admin
- seq_user — INT — Foreign key → tb_user.seq_user
- seq_course — INT — Foreign key → tb_course.seq_course
- seq_book — INT — Foreign key → tb_book.seq_book
- book_dt — DATE — NOT NULL
- return_dt — DATE
tb_sort_first
- seq_sort_first — INT — Primary key — NOT NULL
- kor_sort_first — VARCHAR(255) — NOT NULL
- name_sort_first — VARCHAR(255) — NOT NULL
tb_sort_second
- seq_sort_second — INT — Primary key — NOT NULL
- seq_sort_first — INT — NOT NULL
- kor_sort_second — VARCHAR(255) — NOT NULL
- name_sort_second — VARCHAR(255) — NOT NULL
tb_user
- seq_user — INT — Primary key — NOT NULL
- seq_course — INT — Foreign key → tb_course.seq_course
- id_user — VARCHAR(30) — NOT NULL
- pw_user — VARCHAR(255) — NOT NULL
- name_user — VARCHAR(20) — NOT NULL
- dc_user — VARCHAR(30) — NOT NULL
- agree_terms_user — TINYINT(1) — NOT NULL
- agree_info_user — TINYINT(1) — NOT NULL
- agree_discord_alarm_user — TINYINT(1) — NOT NULL
- status_user — ENUM('stop', 'available', 'overdue') — NOT NULL — stop:정지or탈퇴, available:대여, overdue:연체' NOT NUL
- created_at — DATE — NOT NULL