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)