Healthcare

Tables (5)

table_board (보드테이블)

  • bidx — NUMBER — Primary key
  • boriginbidx — NUMBER — NOT NULL
  • bdepth — NUMBER — NOT NULL
  • blvl — NUMBER — NOT NULL
  • blist — CHAR(1) — NOT NULL — H:건강상담소 Q:문의사항 N:공지사항
  • bcategory — CHAR(5) — LOG:회원가입 AQ:결제 OTHER:기타
  • btitle — VARCHAR(100) — NOT NULL
  • bcontent — VARCHAR2(2000) — NOT NULL
  • bwdate — DATE
  • brewdate — DATE
  • bstate — CHAR(1) — NOT NULL
  • bmdate — DATE
  • bdelete — CHAR(1) — NOT NULL
  • midx — NUMBER — Foreign key → table_member.midx

table_cash (예약 결재 테이블)

  • cidx — NUMBER — Primary key
  • cmoney — NUMBER — NOT NULL
  • cstate — char(1) — NOT NULL — W: 결재대기, S::결재완료, R: 결재취소
  • clist — char(1) — NOT NULL — C: 간편결제 A: 계좌이체, K:카카오,결재 N:네이버결재
  • capst — char(1) — NOT NULL — Y: 결제 완료 N:결제 미완료
  • cdate — DATE
  • rdelete — CHAR(1) — NOT NULL — Y:삭제완료, N:삭제미완료
  • midx — NUMBER — Foreign key → table_member.midx

table_like (추천테이블)

  • midx — NUMBER — Foreign key → table_member.midx
  • bidx — NUMBER — Foreign key → table_board.bidx

table_member (회원테이블)

  • midx — NUMBER — Primary key
  • mid — VARCHAR(12) — NOT NULL
  • mpwd — VARCHAR(12) — NOT NULL
  • mname — VARCHAR(40) — NOT NULL
  • mnumber — NUMBER — NOT NULL
  • mphone — NUMBER — NOT NULL
  • mdelyn — CHAR(1) — NOT NULL — N:회원 Y:탈퇴
  • menter — DATE
  • mmdate — DATE
  • mbreakdate — DATE
  • mcnt — NUMBER
  • mgrade — CHAR(1) — NOT NULL — G:이용자 A:관리자 D:전문의 E:예비회원
  • Field

table_reservelist (예약테이블)

  • ridx — NUMBER — Primary key
  • rcase — CHAR(1) — NOT NULL — H:건강검진, S:예방접종, B:헌혈의 집
  • rlist — VARCHAR2(20) — NOT NULL
  • rmdate — DATE
  • rbuy — NUMBER
  • rdelete — CHAR(1) — NOT NULL — Y:삭제완료, N:삭제미완료
  • midx — NUMBER — Foreign key → table_member.midx