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