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