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