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