hyolo
Tables (11)
customer
- seq_customer_num (일반회원SEQ) — NUMBER — Foreign key → totalmember.seq_member_num — NOT NULL
- gender (일반회원성별) — VARCHAR2(30 BYTE) — NOT NULL
- birthday (일반회원생년월일) — VARCHAR2(100 BYTE) — NOT NULL
- category (일반회원선호카테고리) — VARCHAR2(300 BYTE)
notice
- notice_no (공지사항SEQ) — NUMBER — Primary key — NOT NULL
- notice_division (공지사항분류) — VARCHAR2(100 BYTE) — NOT NULL
- notice_title (공지사항제목) — VARCHAR2(300 BYTE) — NOT NULL
- notice_writer (공지사항작성자) — NUMBER — Foreign key → totalmember.member_id — NOT NULL
- notice_content (공지사항내용) — VARCHAR2(4000 BYTE) — NOT NULL
- notice_date (공지사항작성일) — DATE
- filepath (공지사항첨부파일) — VARCHAR2(300 BYTE)
- readcount (공지사항조회수) — NUMBER
partner
- seq_partner_num (파트너회원SEQ) — NUMBER — Foreign key → totalmember.seq_member_num — NOT NULL
qna
- qna_no (QNASEQ) — NUMBER — Primary key — NOT NULL
- qna_sep (QAN분류) — VARCHAR2(300 BYTE)
- qna_title (QNA제목) — VARCHAR2(50 BYTE)
- qna_writer (QNA작성자) — NUMBER — Foreign key → totalmember.member_id
- qna_content (QNA내용) — VARCHAR2(2000 BYTE)
- qna_date (QNA작성날짜) — DATE
- qna_count (QNA조회수) — NUMBER
qna_comment
- qna_comment_no (QNA댓글SEQ) — NUMBER — Primary key — NOT NULL
- qna_comment_writer (QNA댓글작성자) — NUMBER — Foreign key → totalmember.member_id
- qna_comment_content (QNA댓글내용) — VARCHAR2(2000 BYTE)
- qna_ref (QNA문의업체) — NUMBER — Foreign key → qna.qna_no
- qna_comment_date (QNA작성날짜) — DATE
reservation
- reservation_code (예약 코드SEQ) — NUMBER — Primary key — NOT NULL
- customer_num (예약회원ID) — NUMBER — Foreign key → customer.seq_customer_num — NOT NULL
- store_id (예약업체ID) — NUMBER — Foreign key → store.store_id — NOT NULL
- resevation_date (예약날짜) — VARCHAR2(20 BYTE) — NOT NULL
- reservation_time (예약시간) — NUMBER — NOT NULL
- reservation_requiry (예약요구사항) — VARCHAR2(3000 BYTE)
- payment_code (결제코드) — NUMBER
- rsv_ppl (예약인원) — NUMBER
- pay_date (결제날짜) — DATE
store
- store_id (업체ID) — NUMBER — Primary key — NOT NULL
- category (업체분류) — VARCHAR2(300 BYTE)
- dtl_category (업체소분류) — VARCHAR2(300 BYTE) — NOT NULL
- storename (업체이름) — VARCHAR2(50 BYTE) — NOT NULL
- phone (업체전화번호) — VARCHAR2(300 BYTE) — NOT NULL
- store_post (업체우편번호) — VARCHAR2(50 BYTE) — NOT NULL
- store_addr (업체주소) — VARCHAR2(300 BYTE) — NOT NULL
- store_dtl_addr (업체상세주소) — VARCHAR2(300 BYTE)
- store_extra_addr (업체추가주소) — VARCHAR2(300 BYTE)
- store_content (업체내용) — VARCHAR2(3000 BYTE) — NOT NULL
- homepage (업체사이트) — VARCHAR2(30 BYTE)
- store_profit (업체매출) — VARCHAR2(300 BYTE)
- store_target (업체타깃층) — VARCHAR2(300 BYTE)
- main_img (업체메인이미지) — VARCHAR2(300 BYTE)
- post_img (업체포스트이미지) — VARCHAR2(300 BYTE)
- detail_img (업체상세이미지) — VARCHAR2(300 BYTE)
- ptn_num (파트너ID) — NUMBER — Foreign key → partner.seq_partner_num — NOT NULL
- join_status (업체승인여부) — VARCHAR2(10 BYTE)
- request_date (업체신청날짜) — DATE
- promo_text (업체홍보내용) — VARCHAR2(200 BYTE)
storemenu
- store_id (업체ID) — NUMBER — Foreign key → store.store_id — NOT NULL
- menu_name (업체메뉴이름) — VARCHAR2(100 BYTE)
- menu_price (업체메뉴가격) — NUMBER
- menu_amount (업체메뉴갯수) — NUMBER
- menu_detail (업체메뉴설명) — VARCHAR2(300 BYTE)
- menu_pics (업체메뉴사진) — VARCHAR2(1000 BYTE)
- ptn_num (파트너회원ID) — NUMBER — Foreign key → partner.seq_partner_num
- menu_id_seq (업체메뉴SEQ) — NUMBER — NOT NULL
storeqna
- store_qna_seq (업체문의SEQ) — NUMBER — Primary key — NOT NULL
- qna_content (업체문의내용) — VARCHAR2(2000 BYTE)
- member_num (회원SEQ) — NUMBER — Foreign key → totalmember.seq_member_num
- store_id (업체SEQ) — NUMBER — Foreign key → store.store_id
storeservice
- store_id (업체ID) — NUMBER — Foreign key → store.store_id
- ptn_num (파트너SEQ) — NUMBER — Foreign key → partner.seq_partner_num
- store_day (업체오픈요일) — VARCHAR2(10 BYTE) — NOT NULL
- open_time (업체오픈시간) — NUMBER
- break_start (업체브레이크타임시작) — NUMBER
- break_end (업체브레이크타임끝) — NUMBER
- close_time (업체마감시간) — NUMBER
- store_off (업체휴일) — VARCHAR2(1000 BYTE)
- min_ppl (업체예약최소인원) — NUMBER
- max_ppl (업체예약최대인원) — NUMBER
totalmember
- seq_member_num (회원공통SEQ) — NUMBER — Primary key — NOT NULL
- member_id (회원ID) — VARCHAR2(300 BYTE) — NOT NULL
- member_name (회원이름) — VARCHAR2(100 BYTE) — NOT NULL
- member_sep (회원구분) — VARCHAR2(300 BYTE) — NOT NULL
- member_pw (회원비밀번호) — VARCHAR2(300 BYTE) — NOT NULL
- member_email (회원이메일) — VARCHAR2(300 BYTE)
- member_phone (회원전화번호) — VARCHAR2(300 BYTE) — NOT NULL
- postcode (회원우편번호) — VARCHAR2(100 BYTE) — NOT NULL
- address (회원주소) — VARCHAR2(300 BYTE) — NOT NULL
- detailaddress (회원상세주소) — VARCHAR2(300 BYTE) — NOT NULL
- extraaddress (회원추가주소) — VARCHAR2(300 BYTE)
- enrolldate (가입일) — DATE