딜리와버리

테이블 (11)

별점 (star)

  • 주문코드 (order_code) — number — 외래 키 → 주문내역.주문코드 — NOT NULL — constraint pk_star primary key(order_code)
  • 사업자코드 (company_code) — varchar2(20) — 외래 키 → 음식점.사업자코드 — NOT NULL — constraint fk_star_company foreign key(company_code) references restaurant(company_code) on delete cascade
  • 별점 (star_score) — number — constraint ck_star_score check(star_score in (1,2,3,4,5))

상세주문내역 (order_list)

  • 리스트키 (order_list) — number — 기본 키 — NOT NULL
  • 주문코드 (order_code) — number — 외래 키 → 주문내역.주문코드 — NOT NULL — constraint fk_order_code foreign key(order_code) references order_history(order_code) on delete cascade
  • 음식코드 (food_number) — number — 외래 키 → 음식.음식코드 — constraint fk_order_list_food foreign key(food_number) references food(food_number) on delete set null
  • 수량 (amount) — number

음식 (food)

  • 음식코드 (food_number) — number — 기본 키 — NOT NULL — constraint pk_food_number primary key(food_number)
  • 음식점 (company_code) — varchar2(20) — 외래 키 → 음식점.사업자코드 — NOT NULL — constraint fk_food_company foreign key(company_code) references restaurant(company_code) on delete cascade
  • 가격 (food_price) — number — NOT NULL
  • 음식명 (food_name) — varchar2(100) — NOT NULL

음식장르 (kind)

  • 장르코드 (kind_code) — varchar2(20) — 기본 키 — NOT NULL — constraint pk_kind_code primary key(kind_code)
  • 장르명 (kind_name) — varchar2(20)

음식점 (restaurant)

  • 사업자코드 (company_code) — varchar2(20) — 기본 키 — NOT NULL — constraint pk_company_code primary key(company_code)
  • 음식점 사장님 (member_id) — varchar2(15) — 외래 키 → 회원.아이디 — NOT NULL — constraint fk_member_id foreign key(member_id) references deli_member(member_id) on delete cascade
  • 음식장르 (kind_code) — varchar2(20) — 외래 키 → 음식장르.장르코드 — NOT NULL — constraint fk_kind_code foreign key(kind_code) references kind(kind_code) on delete set null
  • 가게명 (restaurant_name) — varchar2(50) — NOT NULL
  • 가게주소 (restaurant_address) — varchar2(200) — NOT NULL
  • 가게전화번호 (restaurant_phone) — char(11) — NOT NULL
  • 가게이미지 (restaurant_img) — varchar2(300)
  • 댓글란코드 (board_comment_code) — varchar2(10)
  • 별점평균 (star_avg_score) — number

음식점리뷰 (comment_board)

  • 리뷰란 코드 (board_comment_no) — number — 기본 키 — NOT NULL — constraints pk_board_comment primary key(board_comment_no)
  • 리뷰/댓글 구분 (board_comment_level) — number
  • 리뷰/댓글 쓴 회원 (member_id) — varchar2(15) — 외래 키 → 회원.아이디 — NOT NULL — constraints fk_board_comment_writer foreign key (board_comment_writer) references deli_member(member_id) on delete set…
  • 리뷰/댓글 내용 (board_comment_content) — varchar2(2000)
  • 음식점 (company_code) — varchar2(20) — 외래 키 → 음식점.사업자코드 — NOT NULL — constraints fk_company_code_ foreign key(company_code) references restaurant(company_code) on delete cascade
  • 참조번호 (board_comment_ref) — number
  • 작성일 (board_comment_date) — date

장바구니 (cart)

  • 장바구니 번호 (cart_num) — number — 기본 키 — NOT NULL — constraint pk_cart_num primary key(cart_num)
  • 회원아이디 (member_id) — varchar2(15) — 외래 키 → 회원.아이디 — NOT NULL — constraint fk_cart_member foreign key(member_id) references deli_member(member_id) on delete cascade, constraint unique…
  • 총수량 (total_amount) — number
  • 총가격 (total_price) — number

장바구니에 담긴 음식 (cart_list)

  • 리스트 키 (cart_list) — number — 기본 키 — NOT NULL — constraint pk_cart_list primary key(cart_list)
  • 장바구니 번호 (cart_num) — number — 외래 키 → 장바구니.장바구니 번호 — NOT NULL — constraint fk_cart_num foreign key(cart_num) references cart(cart_num) on delete cascade
  • 음식코드 (food_number) — number — 외래 키 → 음식.음식코드 — NOT NULL — constraint fk_cart_list_food foreign key(food_number) references food(food_number) on delete cascade
  • 수량 (amount) — number

주문내역 (order_history)

  • 주문코드 (order_code) — number — 기본 키 — NOT NULL — constraint pk_order_code primary key(order_code)
  • 주문한 회원 (member_id) — varchar2(15) — 외래 키 → 회원.아이디 — NOT NULL — constraint fk_order_member foreign key(member_id) references deli_member(member_id) on delete cascade
  • 음식점 (company_code) — varchar2(20 — NOT NULL
  • 총수량 (total_amount) — number
  • 총가격 (total_price) — number
  • 결제방법 (pay) — varchar2(30)
  • 주문날짜 (order_date) — date

찜리스트 (wishlist)

  • 회원아이디 (member_id) — varchar2(15) — 외래 키 → 회원.아이디 — NOT NULL — constraint pk_wishlist primary key(member_id, company_code), constraint fk_wish_member foreign key(member_id) reference…
  • 음식점 (company_code) — varchar2(20) — 외래 키 → 음식점.사업자코드 — NOT NULL — constraint pk_wishlist primary key(member_id, company_code),constraint fk_wish_company foreign key(company_code) refere…
  • 찜한 날짜 (wish_date) — date

회원 (deli_member)

  • 아이디 (member_id) — varchar2(15) — 기본 키 — NOT NULL — constraint pk_member_id primary key(member_id)
  • 비밀번호 (password) — varchar2(300) — NOT NULL
  • 닉네임 (member_nickname) — varchar2(30) — NOT NULL
  • 이메일 (email) — varchar2(100)
  • 전화번호 (phone) — char(11) — NOT NULL
  • 주소 (address) — varchar2(200) — NOT NULL
  • 역할 (member_role) — char(1) — constraint ck_member_role check(member_role in ('U', 'A', 'C'))
  • 가입일 (enroll_date) — date