캘린더_닥터케어
테이블 (7)
tn_calendar
- CALENDAR_SQ — int — 기본 키 — NOT NULL
- CENTER_SQ — int
- CALENDAR_TYPE — int
- CALENDAR_NAME — varchar(50)
- CALENDAR_ORDER — int
- IS_TOP — int
tn_common
- COMMON_SQ — int — 기본 키 — NOT NULL
- BASE_ID — int
- CODE — int
- NAME — varchar(50)
- DESCRIPTION — varchar(500)
tn_reservation
- RESERVATION_SQ — int — 기본 키 — NOT NULL
- USER_VOUCHER_ID — int — NOT NULL
- STATUS — int — NOT NULL
- MEMO — varchar(1000) — NOT NULL
- CREATE_DATE — timestamp — NOT NULL
tn_room
- ROOM_SQ — int — 기본 키 — NOT NULL
- CENTER_SQ — int
- ROOM_NAME — varchar(50)
- ROOM_ORDER — int
tn_schedule
- SCHEDULE_SQ — int — 기본 키 — NOT NULL
- CENTER_SQ — int — NOT NULL
- SCHEDULE_GROUP_SQ — int
- CALENDAR_SQ — int
- ROOM_SQ — int
- TRAINER_SQ — int
- SCHEDULE_TYPE — int — 1 = 개인 / 2 = 그룹
- COUNT — int
- WAIT_COUNT — int
- START — varchar(50)
- END — varchar(50)
- TITLE — varchar(100)
- MEMO — varchar(1000)
- CREATE_DT — timestamp
- MODIFY_DT — timestamp
tn_schedule_group
- ID — int — 기본 키 — NOT NULL
- CENTER_ID — int
- CREATE_DATE — timestamp
tn_setting
- SETTING_SQ — int — 기본 키 — NOT NULL
- CENTER_SQ — int
- ACTIVE_CALENDAR_SQ — int
- ACTIVE_ROOM_SQ — int
- ACTIVE_TRAINER_SQ — int
- ACTIVE_VIEW_TYPE_SQ — int — NOT NULL
- ACTIVE_TAB_SQ — int — NOT NULL
- START_TIME — varchar(10)
- END_TIME — varchar(10)
- SCHEDULE_TIME_RANGE — int
- SCHEDULE_COLOR_TYPE — int