DB세미나

테이블 (12)

결제 (PAYMENT)

  • Key (pay_seq) — VARCHAR(20) — 기본 키 — NOT NULL
  • Field (pay_kind) — VARCHAR(20)
  • Field (pay_state) — CHAR(4)
  • Field (pay_dayid) — DATETIME
  • Key (reservation_seq) — VARCHAR(30) — 외래 키 → 예약.Key — NOT NULL
  • Field (coupon_seq) — VARCHAR(20) — 외래 키 → 마사지쿠폰.Field — NOT NULL

노쇼 (NO SHOW)

  • Key (reservation_seq) — VARCHAR(30) — 외래 키 → 예약.Key — NOT NULL
  • Field (noshow_date) — DATETIME
  • Field (noshow_content) — TEXT(5000)

댓글 (COMMENT)

  • Key (com_seq) — VARCHAR(20) — 기본 키 — NOT NULL
  • Field (com_content) — TEXT(2000)
  • Field (com_writer) — VARCHAR(20)
  • Field (com_regdate) — DATETIME
  • Field (com_update) — DATETIME
  • Field (del_yn) — CHAR(1)
  • Field (com_deletedate) — DATETIME
  • Key (post_seq) — VARCHAR(20) — 외래 키 → 커뮤니티.Key — NOT NULL

마사지쿠폰 (COUPON)

  • Field (coupon_seq) — VARCHAR(20) — 기본 키 — NOT NULL
  • Field (coupon_name) — VARCHAR(20)
  • Field (coupon_no) — VARCHAR(30)
  • Field (coupon_start) — DATETIME
  • Field (coupon_end) — DATETIME
  • Key (dep_seq) — VARCHAR(20) — 외래 키 → 부서.Key — NOT NULL

부서 (DEPARTMENT)

  • Key (dep_seq) — VARCHAR(20) — 기본 키 — NOT NULL
  • Field (corporate) — VARCHAR(20) — NOT NULL
  • Field (dep_name) — VARCHAR(20) — NOT NULL

예약 (RESERVATION)

  • Key (reservation_seq) — VARCHAR(30) — 기본 키 — NOT NULL
  • Field (reservation_dat) — DATE
  • Field (reservation_time) — TIME
  • Field (reservation_state) — CHAR(4)
  • Key (user_seq) — VARCHAR(20) — 외래 키 → 회원.Key — NOT NULL
  • Key (program_seq) — VARCHAR(20) — 외래 키 → 헬스케어프로그램 구성.Key — NOT NULL
  • Key (option_seq) — VARCHAR(20) — 외래 키 → 헬스케어프로그램 옵션.Key — NOT NULL

이용가능요일 (DAYWEEK)

  • Key (day_seq) — VARCHAR(20) — 기본 키 — NOT NULL
  • Key (day_no) — VARCHAR(20) — NOT NULL
  • Field (day_name) — CHAR(3) — NOT NULL
  • Key (dep_seq) — VARCHAR(20) — 외래 키 → 부서.Key — NOT NULL

진료기록 (CARERECORD)

  • Key (care_seq) — VARCHAR(20) — 기본 키 — NOT NULL
  • Field (care_content) — TEXT(2000)
  • Field (care_writer) — VARCHAR(20)
  • Field (care_regdate) — DATETIME
  • Field (care_update) — DATETIME
  • Field (del_yn) — CHAR(1)
  • Field (care_deletedate) — DATETIME
  • Key (reservation_seq) — VARCHAR(30) — 외래 키 → 예약.Key — NOT NULL

커뮤니티 (COMMUNITY)

  • Key (post_seq) — VARCHAR(20) — 기본 키 — NOT NULL
  • Field (post_category) — VARCHAR(20)
  • Field (post_title) — VARCHAR(50)
  • Field (post_content) — TEXT(5000)
  • Field (post_views) — INTEGER
  • Field (post_writer) — VARCHAR(20)
  • Field (post_regdate) — DATETIME
  • Field (post_update) — DATETIME
  • Field (del_yn) — CHAR(1)
  • Field (post_deletedate) — DATETIME
  • Key (user_seq) — VARCHAR(20) — 외래 키 → 회원.Key — NOT NULL

헬스케어프로그램 구성 (PROGRAM CONFIGURATION)

  • Key (program_seq) — VARCHAR(20) — 기본 키 — NOT NULL
  • Field (program_class) — VARCHAR(20)
  • Field (program_name) — VARCHAR(30)
  • Field (program_content) — TEXT(5000)

헬스케어프로그램 옵션 (PROGRAM OPTIONS)

  • Key (option_seq) — VARCHAR(20) — 기본 키 — NOT NULL
  • Field (option_time) — CHAR(3)
  • Field (option_price) — INTEGER

회원 (USER)

  • Key (user_seq) — VARCHAR(20) — 기본 키 — NOT NULL
  • Key (user_id) — VARCHAR(30) — NOT NULL
  • Field (user_pw) — VARCHAR(50) — NOT NULL
  • Field (user_name) — VARCHAR(20) — NOT NULL
  • Field (usre_phone) — VARCHAR(30) — NOT NULL
  • Field (user_birthday) — DATE — NOT NULL
  • Field (user_rank) — VARCHAR(20) — NOT NULL
  • Field (user_state) — CHAR(1) — NOT NULL
  • Field (user_rating) — CHAR(1) — NOT NULL
  • Key (dep_seq) — VARCHAR(20) — 외래 키 → 부서.Key — NOT NULL