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