딜리와버리
테이블 (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