1인프로젝트
테이블 (16)
Asking (asking)
- ASKING_ID (문의_ID) — VARCHAR(10) — 기본 키 — NOT NULL
- LOW_CATEGORY_ID (소카테고리_ID) — VARCHAR(10) — 외래 키 → LowCategories.LOW_CATEGORY_ID — NOT NULL
- BUYING_ID (구매_ID) — VARCHAR(10) — 외래 키 → Buying.BUYING_ID — NOT NULL
- ASKING_TITLE (문의_제목) — VARCHAR(150)
- ASKING_CONTANT (문의_내용) — VARCHAR(1500)
- ASKING_CREATE_DATE (문의_생성일) — DATETIME
- ASKING_CREATE_BY (문의_생성자) — VARCHAR(10)
- ASKING_MOD_DATE (문의_최종_수정일) — DATETIME
- ASKING_MOD_BY (문의_최종_수정자) — VARCHAR(10)
Basket (basket)
- BASKET_ID (장바구니_ID) — VARCHAR(10) — 기본 키 — NOT NULL
- MEMBER_ID (회원_ID) — VARCHAR(10) — 외래 키 → Members.MEMBER_ID — NOT NULL
- BASKET_CREATE_DATE (장바구니_생성일) — DATETIME
- BASKET_CREATE_BY (장바구니_생성자) — VARCHAR(10)
- BASKET_MOD_DATE (장바구니_최종_수정일) — DATETIME
- BASKET_MOD_BY (장바구니_최종_수정자) — VARCHAR(10)
- BASKET_IS_USE (장바구니_사용여부) — BOOLEAN
BasketGoodsOption (basketGoodsOption)
- BASKET_GOOD_OPTION_ID (장바구니_상품옵션_ID) — VARCHAR(10) — 기본 키 — NOT NULL
- GOOD_OPTION_ID (상품_옵션_ID) — VARCHAR(10) — 외래 키 → GoodsOption.GOOD_OPTION_ID — NOT NULL
- BASKET_ID (장바구니_ID) — VARCHAR(10) — 외래 키 → Basket.BASKET_ID — NOT NULL
- BASKET_GOOD_OPTION_COUNT (상품_옵션_수량) — INT
- BASKET_GOOD_OPTION_CREATE_DATE (장바구니_상품옵션_생성일) — DATETIME
- BASKET_GOOD_OPTION_CREATE_BY (장바구니_상품옵션_생성자) — VARCHAR(10)
- BASKET_GOOD_OPTION_MOD_DATE (장바구니_상품옵션_최종_수정일) — DATETIME
- BASKET_GOOD_OPTION_MOD_BY (장바구니_상품옵션_최종_수정자) — VARCHAR(10)
- BASKET_GOOD_OPTION_IS_USE (장바구니_사품옵션_사용여부) — BOOLEAN
BigCategories (bigCategories)
- BIG_CATEGORY_ID (대카테고리_ID) — VARCHAR(10) — 기본 키 — NOT NULL
- BIG_CATEGORY_NAME (대카테고리_이름) — VARCHAR(45)
- BIG_CATEGORY_CREATE_DATE (대카테고리_생성일) — DATETIME
- BIG_CATEGORY_CREATE_BY (대카테고리_생성자) — VARCHAR(10)
- BIG_CATEGORY_MOD_DATE (대카테고리_수정일) — DATETIME
- BIG_CATEGORY_MOD_BY (대카테고리_수정자) — VARCHAR(10)
- BIG_CATEGORY_IS_USE (대카테고리_수정여부) — BOOLEAN
BrandManager (brandManager)
- BRAND_MANAGER_ID (브랜드_매니저_ID) — VARCHAR(10) — 기본 키 — NOT NULL
- BRAND_ID (브랜드_ID) — VARCHAR(10) — 외래 키 → Brands.BRAND_ID — NOT NULL
- BRAND_MANAGER_NAME (브랜드_매니저_이름) — VARCHAR(20)
- BRAND_MANAGER_TELL_NUMBER (브랜드_매니저_전화번호) — VARCHAR(11)
- BRAND_MANAGER_EMAIL (브랜드_매니저_메일) — VARCHAR(30)
- BRAND_MANAGER_IS (브랜드_매너지_여부) — BOOLEAN
- BRAND_MANAGER_CREATE_DATE (브랜드_매니저_생성일) — DATETIME
- BRAND_MANAGER_CREATE_BY (브랜드_매니저_생성자) — VARCHAR(10)
- BRAND_MANAGER_MOD_DATE (브랜드_매니저_최종_수정일) — DATETIME
- BRAND_MANAGER_MOD_BY (브랜드_매니저_최종_수정자) — VARCHAR(10)
Brands (brands)
- BRAND_ID (브랜드_ID) — VARCHAR(10) — 기본 키 — NOT NULL
- BRAND_CODE (브랜드_코드) — VARCHAR(10)
- BRAND_NAME (브랜드_이름) — VARCHAR(30)
- BRAND_IS_USED (브랜드_사용여부) — BOOLEAN
- BRAND_PROFILE_PATH (브랜드_썸네일_경로) — VARCHAR(200)
- BRAND_CREATE_DATE (브랜드_생성일) — DATETIME
- BRAND_CREATE_BY (브랜드_생성자) — VARCHAR(10)
- BRAND_MOD_DATE (브랜드_최종_수정일) — DATETIME
- BRAND_MOD_BY (브랜드_최종_수정자) — VARCHAR(10)
Buying (buying)
- BUYING_ID (구매_ID) — VARCHAR(10) — 기본 키 — NOT NULL
- BASKET_ID (장바구니_ID) — VARCHAR(10) — 외래 키 → Basket.BASKET_ID — NOT NULL
- DELIVERY_INFO_ID (배송지_ID) — VARCHAR(10) — 외래 키 → DeliveryInfo.DELIVERY_INFO_ID — NOT NULL
- BUYING_CREATE_DATE (구매_생성일) — DATETIME
- BUYING_CREATE_BY (구매_생성자) — VARCHAR(10)
- BUYING_MOD_DATE (구매_최종_수정일) — DATETIME
- BUYING_MOD_BY (구매_최종_수정자) — VARCHAR(10)
- BUYING_HOW_TO (구매_방법) — VARCHAR(30)
- BUYING_DISCOUNT_AMOUNT (구매_총할인_금액) — INT
- BUYING_REAL_AMOUNT (구매_실제_금액) — INT
BuyingDiscount (buyingDiscount)
- BUYING_DISCOUNT_ID (구매_할인_ID) — VARCHAR(10) — 기본 키 — NOT NULL
- BUYING_ID (구매_ID) — VARCHAR(10) — 외래 키 → Buying.BUYING_ID — NOT NULL
- BUYING_DISCOUNT_KIND (구매_할인_방법) — VARCHAR(30)
- BUYING_AMOUNT (구매_할인_금액) — INT
- BUYING_CREATE_DATE (구매_할인_생성일) — DATETIME
- BUYING_CREATE_BY (구매_할인_생성자) — VARCHAR(10)
- BUYING_MOD_DATE (구매_할인_최종_수정일) — DATETIME
- BUYING_MOD_BY (구매_할인_최종_수정자) — VARCHAR(10)
DeliveryInfo (deliveryInfo)
- DELIVERY_INFO_ID (배송지_ID) — VARCHAR(10) — 기본 키 — NOT NULL
- MEMBER_ID (회원_ID) — VARCHAR(10) — 외래 키 → Members.MEMBER_ID — NOT NULL
- DELIVERY_INFO_NAME (배송지명) — VARCHAR(20)
- DELIVERY_INFO_ADDRESS_POST (배송지_우편주소) — VARCHAR(10)
- DELIVERY_INFO_ADDRESS_BASIC (배송지_기본주소) — VARCHAR(100)
- DELIVERY_INFO_ADDRESS_DETAIL (배송지_상세주소) — VARCHAR(100)
- DELIVERY_INFO_NOTE (배송_메시지) — VARCHAR(300)
- DELIVERY_INFO_CREATE_DATE (배송지_생성일) — DATETIME
- DELIVERY_INFO_CREATE_BY (배송지_생성자) — VARCHAR(10)
- DELIVERY_INFO_MOD_DATE (배송지_최종_수정일) — DATETIME
- DELIVERY_INFO_MOD_BY (배송지_최종_수정자) — VARCHAR(10)
- DELIVERY_INFO_IS_USE (배송지_사용여부) — BOOLEAN
- DELIVERY_IS_DEFAULT (배송지_기본_여부) — BOOLEAN
Goods (goods)
- GOOD_ID (상품_ID) — VARCHAR(10) — 기본 키 — NOT NULL
- BRAND_ID (브랜드_ID) — VARCHAR(10) — 외래 키 → Brands.BRAND_ID — NOT NULL
- GOOD_NAME (상품_이름) — VARCHAR(150)
- GOOD_CREATE_DATE (상품_등록일) — DATETIME
- GOOD_CREATE_BY (상품_등록자) — VARCHAR(10)
- GOOD_MOD_DATE (상품_수정일) — DATETIME
- GOOD_MOD_BY (상품_수정자) — VARCHAR(10)
- GOOD_SELLING_COUNT (상품_판매_개수) — VARCHAR(10)
- GOOD_LIKE_COUNT (상품_좋아요_개수) — VARCHAR(10)
- GOOD_GRADE (상품_평점) — VARCHAR(3)
- GOOD_IS_USE (상품_사용_여부) — BOOLEAN
- GOOD_START_DATE (상품_노출_시작일) — DATETIME
- GOOD_END_DATE (상품_노출_종료일) — DATETIME
- GOOD_DISCRIPTION_IMG_PATH (상품_설명_이미지_경로) — VARCHAR(200)
GoodsOption (goodsOption)
- GOOD_OPTION_ID (상품_옵션_ID) — VARCHAR(10) — 기본 키 — NOT NULL
- GOOD_ID (상품_ID) — VARCHAR(10) — 외래 키 → Goods.GOOD_ID — NOT NULL
- GOOD_OPTION_NAME (상품_옵션_이름) — VARCHAR(150)
- GOOD_OPTION_AMOUNT (상품_옵션_수량) — INT
- GOOD_OPTION_PRICE (상품_옵션_원가) — INT
- GOOD_OPTION_DISCOUNT_PER (상품_옵션_할인율) — VARCHAR(5)
- GOOD_OPTION_DISCOUNT_CASH (상품_옵션_할인금액) — INT
- GOOD_OPTION_SELLING_PRICE (상품_옵션_판매가) — INT
- GOOD_OPTION_CREATE_DATE (상품_옵션_생성일) — DATETIME
- GOOD_OPTION_CREATE_BY (상품_옵션_생성자) — VARCHAR(10)
- GOOD_OPTION_MOD_DATE (상품_옵션_최종_수정일) — DATETIME
- GOOD_OPTION_MOD_BY (상품_옵션_최종_수정자) — VARCHAR(10)
- GOOD_OPTION_IS_USE (상품_옵션_사용여부) — BOOLEAN
- GOOD_OPTION_IMG_PATH (상품_옵션_이미지_경로) — VARCHAR(200)
LowCategories (lowCategories)
- LOW_CATEGORY_ID (소카테고리_ID) — VARCHAR(10) — 기본 키 — NOT NULL
- MIDDLE_CATEGORY_ID (중카테고리_ID) — VARCHAR(10) — 외래 키 → MiddleCategories.MIDDLE_CATEGORY_ID — NOT NULL
- LOW_CATEGORY_NAME (소카테고리_이름) — VARCHAR(45)
- LOW_CATEGORY_CREATE_DATE (소카테고리_생성일) — DATETIME
- LOW_CATEGORY_CREATE_BY (소카테고리_생성자) — VARCHAR(10)
- LOW_CATEGORY_MOD_DATE (소카테고리_수정일) — DATETIME
- LOW_CATEGORY_MOD_BY (소카테고리_수정자) — VARCHAR(10)
- LOW_CATEGORY_IS_USE (소카테고리_사용여부) — BOOLEAN
- LOW_CATEGORY_DIVISION (소카테고리_구분) — VARCHAR(1)
LowCategoryGoods (lowCategoryGoods)
- LOW_CATEGORY_GOOD_ID (소카테고리_상품_ID) — VARCHAR(10) — 기본 키 — NOT NULL
- LOW_CATEGORY_ID (소카테고리_ID) — VARCHAR(10) — 외래 키 → LowCategories.LOW_CATEGORY_ID — NOT NULL
- GOOD_ID (상품_ID) — VARCHAR(10) — 외래 키 → Goods.GOOD_ID — NOT NULL
Members (members)
- MEMBER_ID (회원_ID) — VARCHAR(10) — 기본 키 — NOT NULL
- MEMBER_USE_ID (회원_실제_사용_ID) — VARCHAR(15)
- MEMBER_USE_PASSWORD (회원_실제_사용_비밀번호) — VARCHAR(20)
- MEMBER_NAME (회원_이름) — VARCHAR(20)
- MEMBER_TELL_NUMBER (회원_전화번호) — VARCHAR(11)
- MEMBER_TELL_NUMBER_LAST (회원_전화번호_마지막4자리) — VARCHAR(4)
- MEMBER_ADDRESS_BASIC (회원_주소_기본_주소) — VARCHAR(100)
- MEMBER_ADDRESS_POST (회원_우편주소) — VARCHAR(10)
- MEMBER_ADDRESS_DETAIL (회원_주소_상세_주소) — VARCHAR(100)
- MEMBER_EMAIL (회원_이메일) — VARCHAR(30)
- MEMBER_IS_CANCEL (회원_탈퇴여부) — BOOLEAN
- MEMBER_IS_ADMIN (회원_관리자_여부) — BOOLEAN
- MEMBER_CREATE_DATE (회원_생성일) — DATETIME
- MEMBER_CREATE_BY (회원_생성_담당) — VARCHAR(12)
- MEMBER_MOD_DATE (회원_최종_수정일) — DATETIME
- MEMBER_MOD_BY (회원_최종_수정_담당) — VARCHAR(12)
- MEMBER_PROFILE_PATH (회원_프로필_이미지_경로) — VARCHAR(200)
- MEMER_POINT (회원_포인트) — INT
MiddleCategories (middleCategories)
- MIDDLE_CATEGORY_ID (중카테고리_ID) — VARCHAR(10) — 기본 키 — NOT NULL
- BIG_CATEGORY_ID (대카테고리_ID) — VARCHAR(10) — 외래 키 → BigCategories.BIG_CATEGORY_ID — NOT NULL
- MIDDLE_CATEGORY_NAME (중카테고리_이름) — VARCHAR(45)
- MIDDLE_CATEGORY_CREATE_DATE (중카테고리_생성일) — DATETIME
- MIDDLE_CATEGORY_CREATE_BY (중카테고리_생성자) — VARCHAR(10)
- MIDDLE_CATEGORY_MOD_DATE (중카테고리_수정일) — DATETIME
- MIDDLE_CATEGORY_MOD_BY (중카테고리_수정자) — VARCHAR(10)
- MIDDLE_CATEGORY_IS_USE (중카테고리_사용여부) — BOOLEAN
Review (review)
- REVIEW_ID (리뷰_ID) — VARCHAR(10) — 기본 키 — NOT NULL
- GOOD_OPTION_ID (상품_옵션_ID) — VARCHAR(10) — 외래 키 → GoodsOption.GOOD_OPTION_ID — NOT NULL
- REVIEW_CREATE_DATE (리뷰_생성일) — DATETIME
- REVIEW_CREATE_BY (리뷰_생성자) — VARCHAR(10)
- REVIEW_MOD_DATE (리뷰_최종_수정일) — DATETIME
- REVIEW_MOD_BY (리뷰_최종_수정자) — VARCHAR(10)
- REVIEW_TITLE (리뷰_제목) — VARCHAR(60)
- REVIEW_CONTANT (리뷰_내요) — VARCHAR(1500)
- REVIEW_IS_USE (리뷰_사용여부) — BOOLEAN