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