HOSPITAL_ADMIN

Tables (12)

board_notice

  • seq — int(11) — Primary key — NOT NULL
  • title — varchar(200)
  • content — varchar(2000)
  • img — varchar(200)
  • start_date — date
  • credate — timestamp
  • moddate — timestamp

contact

  • seq — int(11) — Primary key — NOT NULL
  • contact_name — varchar(50)
  • hp — varchar(50)
  • subject — varchar(200)
  • content — varchar(1000)
  • start_date — date
  • credate — timestamp — NOT NULL
  • moddate — timestamp — NOT NULL

event

  • seq — int(11) — Primary key — NOT NULL
  • title — varchar(200)
  • img — varchar(500)
  • writer — varchar(50)
  • start_date — date
  • credate — timestamp
  • moddate — timestamp

news

  • seq — int(11) — Primary key — NOT NULL
  • title — varchar(200)
  • content — varchar(2000)
  • img — varchar(200)
  • url — varchar(500)
  • start_date — date
  • credate — timestamp
  • moddate — timestamp

online_counsel

  • seq — int(11) — Primary key — NOT NULL
  • counsel_name — varchar(50)
  • counsel_birth — varchar(20)
  • counsel_hp — varchar(20)
  • counsel_subject — varchar(50)
  • counsel_date — date
  • counsel_time — varchar(50)
  • credate — timestamp — NOT NULL
  • moddate — timestamp — NOT NULL
  • writer — varchar(50)

online_reservation

  • seq — int(11) — Primary key — NOT NULL
  • reserve_name — varchar(50)
  • reserve_birth — varchar(20)
  • reserve_hp — varchar(20)
  • reserve_subject — varchar(50)
  • reserve_date — date
  • reserve_time — varchar(50)
  • credate — timestamp — NOT NULL
  • moddate — timestamp — NOT NULL
  • writer — varchar(50)

online_reservation_child

  • seq — int(11) — Primary key — NOT NULL
  • reserve_name — varchar(50)
  • reserve_birth — varchar(20)
  • reserve_hp — varchar(20)
  • reserve_subject — varchar(50)
  • reserve_date — date
  • reserve_time — varchar(50)
  • credate — timestamp — NOT NULL
  • moddate — timestamp — NOT NULL
  • writer — varchar(50)

operation

  • seq — int(11) — Primary key — NOT NULL
  • title — varchar(200) — NOT NULL
  • method — varchar(200) — NOT NULL
  • name — varchar(200) — NOT NULL
  • age — varchar(200) — NOT NULL
  • job — varchar(200) — NOT NULL
  • img — varchar(200) — NOT NULL
  • content — varchar(2000) — NOT NULL
  • tag — varchar(200) — NOT NULL
  • writer — varchar(200) — NOT NULL
  • start_date — date — NOT NULL
  • credate — timestamp — NOT NULL
  • moddate — timestamp — NOT NULL

popup

  • seq — int(11) — Primary key — NOT NULL
  • class — varchar(100)
  • title — varchar(100)
  • width — varchar(100)
  • height — varchar(100)
  • shift_left — varchar(100)
  • shift_top — varchar(100)
  • content — varchar(500)
  • link — varchar(200)
  • img — varchar(200)
  • start_date — date
  • end_date — date
  • use_yn — varchar(50)
  • date_chk — date
  • credate — timestamp
  • moddate — timestamp

qna

  • seq — int(11) — Primary key — NOT NULL
  • tag — varchar(50)
  • qs — varchar(50)
  • aw — varchar(50)
  • start_date — date
  • credate — timestamp
  • moddate — timestamp

visit

  • seq — int(11) — Primary key — NOT NULL
  • vi_ip — varchar(100) — ip
  • vi_referer — varchar(500)
  • vi_homepage — varchar(100)
  • vi_agent — varchar(100) — pc/mobile
  • vi_browser — varchar(100)
  • vi_os — varchar(100)
  • vi_date — date
  • vi_time — time
  • vi_timestamp — timestamp

visit_sum

  • vi_date — date
  • vi_pc — int(11)
  • vi_mo — int(11)
  • vi_total — int(11)