매드플렉스

테이블 (11)

AdminMember (_admin)

  • id (member_id) — Number — 외래 키 → Member.id — NOT NULL
  • adminGrade (admin_grade) — enum

Brand (tb_brand)

  • id (brand_id) — Number — 기본 키
  • brandCountry (brand_country) — String
  • description — String
  • eng_name — String
  • logo_url — String
  • maker_name — String
  • name — String
  • createDate (create_date) — DateTime — NOT NULL
  • createId (create_id) — String
  • lastModifyDate (last_modify_date) — DateTime — NOT NULL
  • lastModifyId (last_modify_id) — String

BuyerMember (_buyer)

  • id (member_id) — Number — 외래 키 → Member.id — NOT NULL
  • buyerCreditRation (buyer_creadit_ration) — enum

Category (tb_category)

  • id (category_id) — Number — 기본 키
  • name — String
  • useYn (use_yn) — Enum
  • parent_category_id — Number
  • createDate (create_date) — DateTiem — NOT NULL
  • createId (create_id) — String
  • lastModifyDate (last_modify_date) — DateTime — NOT NULL
  • lastModifyId (last_modify_id) — String

Member (tb_member)

  • id (member_id) — Number — 기본 키 — NOT NULL
  • loginId (login_id) — String
  • password — String
  • name — String
  • secretKey (secret_key) — String
  • city — String
  • country — String
  • state — String
  • street1 — String
  • street2 — String
  • tel — String
  • mobile — String
  • zipcode — String
  • useYn (use_yn) — String
  • createDate (create_date) — DateTime
  • createId (create_id) — String
  • lastMOdifyDate (last_modify_date) — DateTeim
  • lastModifyId (last_modify_id) — String

Product (tb_product)

  • id (product_id) — Number — 기본 키
  • categoryId (category_id) — Number — 외래 키 → Category.id
  • brandId (brand_id) — Number — 외래 키 → Brand.id
  • name — String
  • engName (eng_name) — String
  • jpnName (jpn_name) — String
  • cnyName (cny_name) — String
  • currency — String
  • hsCode (hs_code) — String
  • optionType (option_type) — Enum
  • origin — String
  • baseImageUrl (base_image_url) — String
  • additionalImageUrl1 (additional_image_url1) — String
  • additionalImageUrl2 (additional_image_url2) — String
  • additionalImageUrl3 (additional_image_url3) — String
  • sku — String
  • createDate (create_date) — DateTime — NOT NULL
  • createId (create_id) — String
  • lastModifyDate (last_modify_date) — DateTime — NOT NULL
  • lastModifyId (last_modify_id) — String

ProductOption (tb_product_option)

  • id (option_id) — Number — 기본 키
  • productId (product_id) — Number — 외래 키 → Product.id
  • optionTitleId (option_title_id) — Number — 외래 키 → productOptionTitle.id
  • name — String
  • depth — Number
  • isDisplay (is_display) — Boolean
  • isSoldOut (is_sold_out) — Boolean
  • parent_option_id — Number
  • createDate (create_date) — DateTime — NOT NULL
  • createId (create_id) — String
  • lastModifyDate (last_modify_date) — DateTime — NOT NULL
  • lastModifyId (last_modify_id) — String

SellerMember (_seller)

  • id (member_id) — Number — 외래 키 → Member.id — NOT NULL
  • sellerGrade (seller_grade) — enum

SupplyProduct (tb_supply_product)

  • Id (supply_product_id) — Number — 기본 키
  • memberId (member_id) — Number — 외래 키 → SellerMember.id — NOT NULL
  • productId (product_id) — Number — 외래 키 → Product.id
  • maxOrderQuantity (max_order_quantity) — Number
  • supplyPrice (supply_price) — Number
  • supplyType (supply_type) — enum
  • totalStockQuantity (total_stock_quantity) — Number
  • createDate (create_date) — DateTime — NOT NULL
  • createId (create_id) — String
  • lastModifyDate (last_modify_date) — DateTime — NOT NULL
  • lastModifyId (last_modify_id) — String

SupplyProductOption (tb_supply_product_option)

  • id (supply_product_option_id) — Number — 기본 키
  • supplyProductId (supply_product_id) — Number — 외래 키 → SupplyProduct.Id
  • optionId (option_id) — Number — 외래 키 → ProductOption.id
  • isSoldOut (is_sold_out) — Boolean
  • stock — Number
  • createDate (create_date) — DateTime — NOT NULL
  • createId (create_id) — String
  • lastModifyDate (last_modify_date) — DateTeim — NOT NULL
  • lastModifyId (last_modify_id) — String

productOptionTitle (tb_product_option_title)

  • id (option_title_id) — Number — 기본 키
  • kor — String
  • cny — String
  • eng — String
  • jpy — String
  • createDate (create_date) — DateTime — NOT NULL
  • createId (create_id) — String
  • lastModifyDate (last_modify_date) — DateTime — NOT NULL
  • lastModifyId (last_modify_id) — String