캘린더_닥터케어

테이블 (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