bumay_refactoring

Tables (13)

comment

  • id (PK) — varchar(50) — Primary key — NOT NULL
  • user_id (FK2) — varchar(50) — Foreign key → user.id — NOT NULL
  • product_id (F¥K2) — varchar(50) — Foreign key → product.id — NOT NULL
  • author — varchar(225)
  • email — varchar(225)
  • content — varchar(225)
  • datetime — datetime
  • create_id — varchar(225)
  • date_created (Field) — datetime
  • update_id — varchar(225)
  • last_updated — datetime

oauth

  • id (PK) — varchar(50) — Primary key — NOT NULL
  • user_id (FK) — varchar(50) — Foreign key → user.id — NOT NULL
  • version — bigint(20)
  • access_token — varchar(225)
  • provider — varchar(225)

order

  • id (PK) — varchar(50) — Primary key — NOT NULL
  • user_id (FK) — varchar(50) — Foreign key → user.id — NOT NULL
  • transaction_id — varchar(50)
  • product_order_date — datetime
  • progress — boolean
  • order — boolean
  • row_num — varchar(50)
  • product_url — varchar(1000)
  • product_count — varchar(50)
  • product_color — varchar(1000)
  • product_delivery_method — varchar(50)
  • product_customer_jp_name — varchar(50)
  • product_customer_jp_address — varchar(1000)
  • product_customer_en_name — varchar(50)
  • product_customer_postal_code — varchar(50)
  • product_customer_en_address — varchar(1000)
  • product_customer_cell_phone_number — varchar(50)
  • tracking_number — varchar(50)
  • product_profit — varchar(50)
  • shipping_total_cost — varchar(1000)
  • product_type_en — varchar(50)
  • product_weight — varchar(50)
  • product_price_en — varchar(50)
  • confirmation_id — varchar(50)
  • product_customer_en_address_1 — varchar(1000)
  • product_customer_en_address_2 — varchar(1000)
  • product_customer_en_address_3 — varchar(1000)
  • product_customer_en_address_4 — varchar(1000)
  • comment — varchar(2000)
  • product_title — varchar(1000)
  • naver_item_id — varchar(50)
  • invoice_number — varchar(50)
  • create_id — varchar(225)
  • date_created — datetime
  • update_id — varchar(225)
  • last_updated — datetime

other_seller

  • id (PK) — varchar(50) — Primary key — NOT NULL
  • user_id (FK) — varchar(50) — Foreign key → user.id — NOT NULL
  • buyma_user_id — varchar(225)
  • buyma_home_url — varchar(225)
  • create_id — varchar(225)
  • date_created — datetime
  • update_id — varchar(225)
  • last_updated — datetime

other_seller_infomation

  • id (PK) — varchar(50) — Primary key — NOT NULL
  • other_seller_id (FK) — varchar(50) — Foreign key → other_seller.id — NOT NULL
  • buyma_user_id — varchar(225)
  • buyma_home_url — varchar(225)
  • main_category — varchar(225)
  • follower — varchar(225)
  • number_of_listings — varchar(225)
  • create_id — varchar(225)
  • date_created — datetime
  • update_id — varchar(225)
  • last_updated — datetime

other_seller_product

  • id (PK) — varchar(50) — Primary key — NOT NULL
  • other_seller_id (FK) — varchar(50) — Foreign key → other_seller.id — NOT NULL
  • buyma_product_id — varchar(225)
  • buyma_product_name — varchar(225)
  • wish — bigint(20)
  • access — bigint(20)
  • create_id — varchar(225)
  • date_created — datetime
  • update_id — varchar(225)
  • last_updated — datetime

other_seller_product_tag

  • id (PK) — varchar(50) — Primary key — NOT NULL
  • other_seller_id (FK) — varchar(50) — Foreign key → other_seller_product.id — NOT NULL
  • buyma_product_tag — varchar(225)
  • create_id — varchar(225)
  • date_created — datetime
  • update_id — varchar(225)
  • last_updated — datetime

other_seller_product_today_count (ther_seller_product_today_count)

  • id (PK) — varchar(50) — Primary key — NOT NULL
  • other_seller_product_id (FK) — varchar(50) — Foreign key → other_seller_product.id — NOT NULL
  • buyma_product_id — varchar(50)
  • buyma_product_name — varchar(225)
  • today — datetime
  • wish — bigint(20)
  • access — bigint(20)
  • link — varchar(225)
  • create_id — varchar(225)
  • date_created — datetime
  • update_id — varchar(225)
  • last_updated — datetime

product

  • id (PK) — varchar(50) — Primary key — NOT NULL
  • user_id (FK) — varchar(50) — Foreign key → user.id — NOT NULL
  • buyma_product_id — varchar(50)
  • buyma_product_name — varchar(225)
  • buyma_product_status — varchar(225)
  • buyma_product_realease_date — datetime
  • cart — bigint(20)
  • wish — bigint(20)
  • access — bigint(20)
  • create_id — varchar(225)
  • date_created — datetime
  • update_id — varchar(225)
  • last_updated — datetime

product_today_count

  • id (PK) — varchar(50) — Primary key — NOT NULL
  • product_id (FK) — varchar(50) — Foreign key → product.id — NOT NULL
  • buyma_product_id — varchar(50)
  • buyma_product_name — varchar(225)
  • today — datetime
  • cart — bigint(20)
  • wish — bigint(20)
  • access — bigint(20)
  • link — varchar(225)
  • create_id — varchar(225)
  • date_created — datetime
  • update_id — varchar(225)
  • last_updated — datetime

temporary_other_seller_product_count

  • id (PK) — varchar(50) — Primary key — NOT NULL
  • buyma_product_id — varchar(50)
  • buyma_product_name — varchar(225)
  • buyma_product_status — varchar(225)
  • buyma_product_realease_date — datetime
  • today — datetime
  • wish — bigint(20)
  • access — bigint(20)

temporary_product_count

  • id (PK) — varchar(50) — Primary key — NOT NULL
  • buyma_product_id — varchar(50)
  • buyma_product_name — varchar(225)
  • buyma_product_status — varchar(225)
  • buyma_product_realease_date — datetime
  • today — datetime
  • cart — bigint(20)
  • wish — bigint(20)
  • access — bigint(20)

user

  • id (PK) — varchar(50) — Primary key — NOT NULL
  • password — varchar(225)
  • nickname — varchar(225)
  • email — varchar(225)
  • isblock (Field) — boolean
  • role (Field2) — varchar(50)
  • create_id — varchar(225)
  • date_created — datetime
  • update_id — varchar(225)
  • last_updated — datetime