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')