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