F-LAB

Tables (6)

Member (회원)

  • member_id (Key) — NOT NULL — Primary key — NOT NULL
  • member_email (이메일) — NOT NULL
  • member_password (비밀번호) — NOT NULL
  • member_name (이름) — NOT NULL
  • admin_yn (관리자여부) — NOTNULL
  • create_date (수정일자) — NOTNULL
  • update_date (Field) — NOTNULL

Product (상품)

  • product_id (상품번호) — NOT NULL — Primary key — NOT NULL
  • product_code (상품코드) — NOT NULL
  • product_name (상품이름) — NOT NULL
  • product_price (상품가격) — NOT NULL
  • product_coment (상품설명) — NOT NULL
  • create_date (생성일자) — NOTNULL
  • update_date (수정일자) — NOTNULL

Product_color (색상)

  • color_id (색상번호) — NOT NULL — Primary key — NOT NULL
  • color_name (색상이름) — NOT NULL
  • create_date (생성일자) — NOTNULL
  • update_date (수정일자) — NOTNULL
  • product_id (상품번호) — NOT NULL — Foreign key → Product.product_id — NOT NULL

Product_image (상품이미지)

  • image_id (이미지번호) — NOT NULL — Primary key — NOT NULL
  • product_id (상품번호) — NOT NULL — Foreign key → Product.product_id — NOT NULL
  • file_name (이미지파일이름) — NOT NULL
  • create_date (생성일자) — NOTNULL
  • update_date (수정일자) — NOTNULL

Product_size (사이즈)

  • size_id (사이즈번호) — NOT NULL — Primary key — NOT NULL
  • size_code (사이즈코드) — NOT NULL
  • create_date (생성일자) — NOTNULL
  • update_date (수정일자) — NOTNULL
  • product_id (상품번호) — NOT NULL — Foreign key → Product.product_id — NOT NULL

order (주문)

  • order_id (주문번호) — NOT NULL — Primary key — NOT NULL
  • order_date (주문날짜) — NOT NULL
  • order_count (주문수량) — NOT NULL
  • member_id (회원번호) — NOT NULL — Foreign key → Member.member_id — NOT NULL
  • product_id (상품번호) — NOT NULL — Foreign key → Product.product_id — NOT NULL
  • create_date (생성일자) — NOTNULL
  • update_date (수정일자) — NOTNULL