bts

Tables (3)

board

  • id (writer) — varchar2(50) — Foreign key → par_member.kid_id — NOT NULL
  • num — number
  • title — varchar2(50)
  • content — varchar(500)
  • writedate — date

member

  • id — varchar2(50) — Primary key — NOT NULL
  • password — varchar2(50)
  • name — varchar(50)
  • birth — date
  • tel — varchar2(50)
  • address — varchar2(50)
  • score — number

par_member

  • kid_id — varchar2(50) — Foreign key → member.id — NOT NULL
  • par_id — varchar2(50)
  • par_password — varchar2(50)
  • par_name — varchar2(50)
  • par_birth — date
  • par_tel — varchar2(50)
  • par_address — varchar2(50)