shop

Tables (4)

order (주문목록)

  • order_id (주문번호) — BIGINT — Primary key — NOT NULL
  • member_id (회원번호) — BIGINT — Foreign key → user.member_id — NOT NULL
  • order_time (주문시각) — datetime — NOT NULL
  • order_status (주문 상태) — CHAR(255) — NOT NULL
  • order_price (주문 총 금액) — BIGINT — NOT NULL

order_detail (주문 상세)

  • id (주문상세번호) — BIGINT — Primary key — NOT NULL
  • order_id (주문번호) — BIGINT — Foreign key → order.order_id — NOT NULL
  • product_id (상품번호) — BIGINT — Foreign key → product.product_id — NOT NULL
  • order_quentity (주문수량) — BIGINT — NOT NULL

product (상품목록)

  • product_id (상품번호) — BIGINT — Primary key — NOT NULL
  • member_id (회원번호) — BIGINT — Foreign key → user.member_id — NOT NULL
  • product_name (상품명) — CHAR(255) — NOT NULL
  • stock (재고수량) — BIGINT — NOT NULL
  • price (개당 가격) — BIGINT — NOT NULL

user (회원목록)

  • member_id (회원번호) — BIGINT — Primary key — NOT NULL
  • name (회원이름) — CHAR(255) — NOT NULL
  • telNo (전화번호) — CHAR(255) — NOT NULL
  • address (주소) — CHAR(255) — NOT NULL
  • role (역할) — CHAR(255) — NOT NULL