glass_time_studio
Tables (14)
Announcement (Untitled10)
- 공지id (announcement_id) — PK — Primary key — NOT NULL
- 직원id (manager_id) — FK — Foreign key → manager.직원id — NOT NULL
- 제목 (announcement_title) — String
- 내용 (announcement_content) — String
basket (Untitled2)
- 장바구니id (basket_id) — PK — Primary key — NOT NULL
basket_product (Untitled14)
- basket_product_id — PK — Primary key — NOT NULL
- 장바구니id (basket_id) — FK — Foreign key → basket.장바구니id — NOT NULL
- 제품 id (product_id) — FK — Foreign key → product.제품 id — NOT NULL
booking (Untitled8)
- 예약id (booking_id) — PK — Primary key — NOT NULL
- 회원id (member_id) — FK — Foreign key → member.회원id — NOT NULL
- 클래스id (class_id) — FK — Foreign key → class.클래스id — NOT NULL
- 장바구니id (basket_id) — PK — Foreign key → member.장바구니id — NOT NULL
- 예약요청날짜 (req_date)
- 예약요청시간 (req_time)
- 참여인원 (ppl_num)
- 메세지 (message) — String
class (Untitled7)
- 클래스id (class_id) — PK — Primary key — NOT NULL
- 클래스이름 (class_name) — String
- 클래스가격 (class_price)
comment (Untitled11)
- 댓글id (comment_id) — PK — Primary key — NOT NULL
- 리뷰id (review_id) — FK — Foreign key → review.리뷰id — NOT NULL
- 예약id (booking_id) — PK — Foreign key → review.예약id — NOT NULL
- 장바구니id (basket_id) — PK — Foreign key → review.장바구니id — NOT NULL
- 댓글내용 (comment_body) — String
manager (Untitled3)
- 직원id (manager_id) — PK — Primary key — NOT NULL
- 직원이름 (name)
- 직원 권한 (permit)
member (Untitled)
- 회원id (member_id) — PK — Primary key — NOT NULL
- 장바구니id (basket_id) — PK — Foreign key → basket.장바구니id — NOT NULL
- 이름 (name)
- 휴대폰번호 (phone)
- 이메일 주소 (email)
- 주소 (address)
member_permit (Untitled12)
- member_permit_id — PK — Primary key — NOT NULL
- 회원id (member_id) — FK — Foreign key → member.회원id — NOT NULL
- 권한id (permit_id2) — FK — Foreign key → permit.권한id — NOT NULL
- 장바구니id (basket_id) — PK — Foreign key → member.장바구니id — NOT NULL
order (Untitled6)
- 주문 id (order_id) — PK — Primary key — NOT NULL
- 회원id (member_id) — FK — Foreign key → member.회원id — NOT NULL
- 장바구니id (basket_id2) — FK — Foreign key → basket.장바구니id — NOT NULL
- 생성날짜 (created_at)
- 주문상태 (status)
- 변경날짜 (modified_at)
permit (Untitled4)
- 권한id (permit_id) — PK — Primary key — NOT NULL
- 권한 (permit) — String
product (Untitled5)
- 제품 id (product_id) — PK — Primary key — NOT NULL
- 제품 이름 (product_title) — String
- 제품 설명 (product_description) — String
- 제품이미지_1 (product_img_1) — String — 이미지 URL
- 제품이미지_2 (product_img_2) — String
- 제품이미지_3 (product_img_3) — String
- 제품이미지_4 (product_img_4) — String
- 제품이미지_5 (product_img_5) — String
- 제품이미지_6 (product_img_6) — String
- 제품이미지_7 (product_img_7) — String
- 제품이미지_8 (product_img_8) — String
- 제품이미지_9 (product_img_9) — String
- 제품이미지_10 (product_img_10) — String
- 제품이미지_11 (product_img_11) — String
- 제품이미지_12 (product_img_12) — String
- 제품 가격 (product_price)
- 제품 재고량 (product_quantity)
product_order (Untitled13)
- product_order_id — PK — Primary key — NOT NULL
- 제품 id (product_id) — FK — Foreign key → product.제품 id — NOT NULL
- 주문 id (order_id2) — FK — Foreign key → order.주문 id — NOT NULL
- 회원id (member_id) — FK — Foreign key → order.회원id — NOT NULL
- 장바구니id (basket_id2) — PK — Foreign key → order.장바구니id — NOT NULL
- Field
review (Untitled9)
- 리뷰id (review_id) — PK — Primary key — NOT NULL
- 예약id (booking_id) — FK — Foreign key → booking.예약id — NOT NULL
- 장바구니id (basket_id) — PK — Foreign key → booking.장바구니id — NOT NULL
- 제목 (review_title) — String
- 내용 (review_content) — String