매드플렉스
테이블 (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