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