classBoard

Tables (4)

tb_ exception_word

  • exception_seq — int — Primary key — NOT NULL
  • exception_name — varchar(100)
  • exception_memo — varchar(200)
  • delete_yn — varchar(1)
  • in_id — varchar(100)
  • in_dtmi (in_dtm) — datetime
  • up_id — varchar(100)
  • up_dtm — datetime

tb_class_board

  • class_seq — int — Primary key — NOT NULL
  • class_name — varchar(200)
  • class_content — mediumtext
  • delete_yn — varchar(1)
  • in_id — varchar(100)
  • in_dtm — datetime
  • up_id — varchar(100)
  • up_dtm — datetime

tb_contain

  • contain_seq — int — Primary key — NOT NULL
  • class_seq — int — Foreign key → tb_class_board.class_seq — NOT NULL
  • word_seq — int — Foreign key → tb_word.word_seq — NOT NULL
  • contain_cnt — int
  • in_id — varchar(100)
  • in_dtm — datetime

tb_word

  • word_seq — int — Primary key — NOT NULL
  • word_name — varchar(200)
  • in_id — varchar(100)
  • in_dtm — datetime