brief

Tables (40)

Banner (배너)

  • BannerId (banner_id) — not null — Primary key — NOT NULL
  • Name (name) — not null
  • Thumb (thumb) — not null
  • Status (status) — not null
  • Sort (sort) — not null
  • RegDate (reg_date) — not null
  • UpdateDate (update_date) — not null

Category (카테고리)

  • CategoryId (category_id) — not null — Primary key — NOT NULL
  • ParentId (parent_id) — not null
  • Depth (depth) — not null
  • Name (name) — not null
  • Sort (sort) — not null
  • RegDate (reg_date) — not null
  • UpdateDate (update_date) — not null

Certification (인증)

  • CertificationId (certification_id) — not null — Primary key — NOT NULL

CertificationMethod (인증수단)

  • CertificationMethodId (certification_method_id) — not null — Primary key — NOT NULL
  • CertificationId (certification_id) — not null — Foreign key → Certification.CertificationId — NOT NULL
  • MethodId (method_id2) — not null — Foreign key → Method.MethodId — NOT NULL

CompanyInformation (회사정보)

  • CompanyInformationId (company_information_id) — not null — Primary key — NOT NULL
  • KorName (kor_name) — not null
  • EngName (eng_name) — not null
  • BusinessNumber (business_number) — not null
  • Tel (tel) — not null
  • Phone (phone) — not null
  • Fax (fax) — not null
  • Address (address) — not null

Coupon (쿠폰)

  • CouponId (coupon_id) — not null — Primary key — NOT NULL
  • Name (name) — not null
  • Code (code) — not null
  • Phone (phone) — not null
  • RegDate (reg_date) — not null
  • UpdateDate (update_date) — not null

Faq (자주묻는질문)

  • FaqId (faq_id) — not null — Primary key — NOT NULL
  • FaqCategoryId (faq_category_id) — not null — Foreign key → FaqCategory.FaqCategoryId — NOT NULL
  • Question (question) — not null
  • Answer (answer) — not null
  • Sort (sort) — not null
  • Hashtag (hashtag) — null
  • RegDate (reg_date) — not null
  • UpdateDate (update_date) — not null

FaqCategory (자주묻는질문 카테고리)

  • FaqCategoryId (faq_category_id) — not null — Primary key — NOT NULL
  • Name (name) — not null
  • Sort (sort) — not null
  • RegDate (reg_date) — not null
  • UpdateDate (update_date) — not null

Input (입력칸)

  • InputId (input_id) — not null — Primary key — NOT NULL
  • Name (name) — not null
  • Type (type) — not null
  • Length (length) — not null
  • RegDate (reg_date) — null
  • UpdateDate (update_date) — null

Menu (메뉴)

  • MenuId (menu_id) — not null — Primary key — NOT NULL
  • Name (name) — not null
  • Url (url) — not null
  • Sort (sort) — not null
  • Status (status) — not null
  • Type (type) — not null
  • Role (role) — not null
  • RegDate (reg_date) — not null
  • UpdateDate (update_date) — not null

MenuBanner (메뉴배너)

  • MenuBannerId (menu_banner_id) — not null — Primary key — NOT NULL
  • MenuId (menu_id) — not null — Foreign key → Menu.MenuId — NOT NULL
  • BannerId (banner_id2) — not null — Foreign key → Banner.BannerId — NOT NULL

MenuPopup (메뉴팝업)

  • MenuPopupId (menu_popup_id) — not null — Primary key — NOT NULL
  • MenuId (menu_id) — not null — Foreign key → Menu.MenuId — NOT NULL
  • PopupIdp (popup_id2) — not null — Foreign key → Popup.PopupId — NOT NULL

MenuTerm (메뉴약관)

  • MenuTermId (menu_term_id) — not null — Primary key — NOT NULL
  • MenuId (menu_id) — not null — Foreign key → Menu.MenuId — NOT NULL
  • TermId (term_id2) — not null — Foreign key → Term.TermId — NOT NULL

Method (수단)

  • MethodId (method_id) — not null — Primary key — NOT NULL

Notice (공지사항)

  • NoticeId (notice_id) — not null — Primary key — NOT NULL
  • Subject (subject) — not null
  • Description (description) — not null
  • File (file) — null
  • RegDate (reg_date) — null
  • UpdateDate (update_date) — null
  • Sort (sort) — not null

Option (옵션)

  • OptionId (option_id) — not null — Primary key — NOT NULL
  • Required (required) — not null
  • ParentId (parent_id) — not null
  • Depth (depth) — not null
  • Name (name) — not null
  • Price (price) — not null
  • Sale (sale) — not null
  • SalePrice (sale_price) — not null
  • Sort (sort) — not null
  • RegDate (reg_date) — not null
  • UpdateDate (update_date) — not null

OptionStock (옵션재고)

  • OptionStockId (option_stock_id) — not null — Primary key — NOT NULL
  • OptionId (option_id) — not null — Foreign key → Option.OptionId — NOT NULL
  • StockId (stock_id) — not null — Foreign key → Stock.PartId — NOT NULL

Order (주문)

  • OrderId (order_id) — not null — Primary key — NOT NULL
  • PaymentId (payment_id) — not null — Foreign key → Payments.PaymentId — NOT NULL
  • TotalPrice (total_price) — not null
  • SalePrice (sale_price) — not null
  • TotalCount (total_count) — not null
  • TotalDelivery (total_delivery) — not null
  • RegDate (reg_date) — not null
  • UpdateDate (update_date) — not null

OrderCoupon (주문쿠폰)

  • OrderCouponId (order_coupon_id) — not null — Primary key — NOT NULL
  • OrderProductId (order_product_id) — not null — Foreign key → OrderProduct.OrderProductId — NOT NULL
  • CouponId (coupon_id2) — not null — Foreign key → Coupon.CouponId — NOT NULL
  • Field

OrderProduct (주문상품)

  • OrderProductId (order_product_id) — not null — Primary key — NOT NULL
  • OrderId (order_id) — not null — Foreign key → Order.OrderId — NOT NULL
  • ProductName (product_name) — not null
  • Thumbnail (thumbnail) — not null
  • ProductPrice (product_price) — not null
  • ProductSalePrice (product_sale_price) — not null

OrderProductOption (주문상품옵션)

  • OrderProductOptionId (order_product_option_id) — not null — Primary key — NOT NULL
  • OrderProductId (order_product_id) — not null — Foreign key → OrderProduct.OrderProductId — NOT NULL
  • OptionName (option_name) — not null
  • OptionCount (option_count) — not null
  • OptionPrice (option_price) — not null
  • OptionSalePrice (option_sale_price) — not null
  • Delivery (delivery) — not null
  • RegDate (reg_date) — not null

Orderer (주문자)

  • OrdererId (orderer_id) — not null — Primary key — NOT NULL
  • OrderId (order_id) — not null — Foreign key → Order.OrderId — NOT NULL
  • Name (name) — not null
  • Email (email) — not null
  • Phone (phone) — not null
  • Description (description) — not null
  • RegDate (reg_date) — not null
  • UpdateDate (update_date) — not null

Payments (결제)

  • PaymentId (payment_id) — not null — Primary key — NOT NULL
  • ImpUid (imp_uid) — not null
  • MerchantUid (merchant_uid) — not null
  • TotalPayment (total_payment) — not null
  • CouponId (coupon_id) — null
  • CouponDiscount (coupon_discount) — not null
  • BuyerName (buyer_name) — not null
  • BuyerEmail (buyer_email) — not null
  • BuyerPhone (buyer_phone) — not null
  • BuyerPost (buyer_post) — not null
  • BuyerAddress1 (buyer_address1) — not null
  • BuyerAddress2 (buyer_address2) — not null
  • Status (status) — not null
  • RegDate (reg_date) — not null
  • UpdateDate (update_date) — not null
  • DeliveryNote (delivery_note) — not null
  • PayMethod (pay_method) — not null
  • PgProvider (pg_provider) — not null
  • PgTid (pg_tid) — not null
  • Escrow (escrow) — not null
  • ApplyNum (apply_num) — not null
  • CardName (card_name) — not null
  • CardQuota (card_quota) — not null
  • VbankName (vbank_name) — null
  • VbankNum (vbank_num) — null
  • VbankDate (vbank_date) — null
  • Name (name) — not null
  • Amount (amount) — not null
  • CancelAmount (cancel_amount) — not null
  • PaidAt (paid_at) — null
  • FailedAt (failed_at) — null
  • CancelledAt (cancelled_at) — null
  • FailedReason (failed_reason) — null
  • CancelledReason (cancelled_reason) — null
  • ReceiptUrl (receipt_url) — null
  • RefundHolder (refund_holder) — null
  • RefundBank (refund_bank) — null
  • RefundAccount (refund_account) — null
  • Password (password) — not null
  • DepositName (deposit_name) — null
  • ReceiveName (receive_name) — null
  • ReceivePhone (receive_phone) — null

Popup (팝업)

  • PopupId (popup_id) — not null — Primary key — NOT NULL
  • Name (name) — not null
  • Thumb (thumb) — not null
  • Status (status) — not null
  • Sort (sort) — not null
  • RegDate (reg_date) — not null
  • UpdateDate (update_date) — not null

Product (상품)

  • ProductId (product_id) — not null — Primary key — NOT NULL
  • ProductTypeId (product_type_id) — not null — Foreign key → ProductType.ProductTypeId — NOT NULL
  • Name (name) — not null
  • Description (description) — not null
  • Thumb (thumb) — not null
  • Price (price) — not null
  • SalePrice (sale_price) — not null
  • Sale (sale) — not null
  • ViewCount (view_count) — not null
  • Status (status) — not null
  • Score (score) — not null
  • RegDate (reg_date) — not null
  • UpdateDate (update_date) — not null

ProductCategory (상품카테고리)

  • ProductCategoryId (product_category_id) — not null — Primary key — NOT NULL
  • ProductId (product_id) — not null — Foreign key → Product.ProductId — NOT NULL
  • CategoryId (category_id) — not null — Foreign key → Category.CategoryId — NOT NULL

ProductOption (상품옵션)

  • ProductOptionId (product_option_id) — not null — Primary key — NOT NULL
  • ProductId (product_id) — not null — Foreign key → Product.ProductId — NOT NULL
  • Oid (o_id2) — not null — Foreign key → Option.OptionId — NOT NULL
  • Field

ProductThumb (상품 썸네일)

  • ProductThumbId (product_thumb_id) — not null — Primary key — NOT NULL
  • ProductId (product_id) — not null — Foreign key → Product.ProductId — NOT NULL
  • ThumbId (thumb_id) — not null — Foreign key → Thumb.ThumbId — NOT NULL

ProductType (상품유형)

  • ProductTypeId (product_type_id) — not null — Primary key — NOT NULL
  • Name (name) — not null
  • RegDate (reg_date) — null
  • UpdateDate (update_date) — null

ProductTypeInput (상품입력칸)

  • ProductTypeInputId (product_type_input_id) — not null — Primary key — NOT NULL
  • ProductTypeId (product_type_id) — not null — Foreign key → ProductType.ProductTypeId — NOT NULL
  • InputId (input_id) — not null — Foreign key → Input.InputId — NOT NULL
  • ValueId (value_id) — not null — Foreign key → Value.ValueId — NOT NULL
  • Sort (sort) — not null
  • RegDate (reg_date) — not null
  • UpdateDate (update_date) — not null

Review (리뷰)

  • ReviewId (review_id) — not null — Primary key — NOT NULL
  • ProductId (product_id) — not null — Foreign key → Product.ProductId — NOT NULL
  • OrdererId (orderer_id) — not null — Foreign key → Orderer.OrdererId — NOT NULL
  • Star (star) — not null
  • Type (type) — not null
  • Description (description) — not null
  • Like (like) — not null
  • Subjects (subject) — not null
  • RegDate (reg_date) — not null

ReviewPhoto (리뷰사진)

  • PhotoId (photo_id) — not null — Primary key — NOT NULL
  • ReviewId (review_id) — not null — Foreign key → Review.ReviewId — NOT NULL
  • OrdererId (orderer_id) — not null — Foreign key → Review.OrdererId — NOT NULL
  • Path (path) — not null
  • Status (status) — not null
  • RegDate (reg_date) — not null

Shipping (배송)

  • ShippingId (shipping_id) — not null — Primary key — NOT NULL
  • OrderProductId (order_product_id) — not null — Foreign key → OrderProduct.OrderProductId — NOT NULL
  • Post (post) — not null
  • FrontAddress (front_address) — not null
  • BackAddress (back_address) — not null
  • NeedDate (need_date) — not null
  • RegDate (reg_date) — not null
  • UpdateDate (update_date) — not null

Stock (재고)

  • PartId (stock_id) — not null — Primary key — NOT NULL
  • Name (name) — not null
  • Count (count) — not null
  • RegDate (reg_date) — not null
  • UpdateDate (update_date) — not null

StockSpecification (재고명세서)

  • StockSpecificationId (stock_specification_id) — not null — Primary key — NOT NULL
  • PartId (stock_id) — not null — Foreign key → Stock.PartId — NOT NULL
  • Subject (subject) — not null
  • Description (description) — not null
  • RegDate (reg_date) — not null
  • UpdateDate (update_date) — not null

Term (약관)

  • TermId (term_id) — not null — Primary key — NOT NULL
  • Subject (subject) — not null
  • Description (description) — not null
  • Status (status) — not null
  • Sort (sort) — not null
  • Required (required) — not null
  • RegDate (reg_date) — not null

Thumb (썸네일)

  • ThumbId (thumb_id) — not null — Primary key — NOT NULL
  • Url (url) — not null
  • Status (status) — not null
  • Sort (sort) — not null
  • RegDate (reg_date) — not null
  • UpdateDate (update_date) — not null

User (회원)

  • UserId (user_id) — not null — Primary key — NOT NULL
  • Password (password) — not null
  • Name (name) — not null
  • NickName (nick_name) — null
  • Eamil (email) — null
  • Phone (phone) — null
  • Status (status) — not null
  • RegDate (reg_date) — null
  • UpdateDate (update_date) — null

UserRole (회원권한)

  • Role (role) — not null — Primary key — NOT NULL
  • UserId (user_id) — not null — Foreign key → User.UserId — NOT NULL
  • Status (status) — not null

Value (값)

  • ValueId (value_id) — not null — Primary key — NOT NULL
  • Val (val) — null
  • RegDate (reg_date) — not null
  • UpdateDate (update_date) — not null