da
Tables (6)
v_trd_category (Untitled2)
- id (Key) — str — Primary key — NOT NULL
- platform (Field) — str
- lv1_category_kr (Field2) — str
- lv1_category_en (Field3) — str
- lv2_category_kr (Field4) — str
- lv2_category_en (Field5) — str
- lv3_category_kr (Field6) — str
- lv3_category_en (Field7) — str
- is_active (Field8) — bool
v_trd_ingredient (Untitled6)
- da_len_rawcdk (Field) — int
- da_rawcdk (Field2) — str
- da_rawcde (Field3) — str
v_trd_popular_rank (Untitled4)
- id (Key) — Primary key — NOT NULL
- category_id (Key2) — str — Foreign key → v_trd_category.id — NOT NULL
- platform (Field) — str
- uid (Field2) — str
- rank (Field3) — int
- base_time (Field4) — date
- cdc_date (Field5) — date
v_trd_post (Untitled5)
- id (Key) — str — Primary key — NOT NULL
- category_id (Key2) — str — Foreign key → v_trd_category.id — NOT NULL
- platform (Field) — str
- time_range (Field2) — str
- content (Field3) — str
- item_id (Field4) — str
- product_title (Field5) — str
- posted_at (Field6) — str
- brand (Field7) — str
- author_name (Field8) — str
- rate (Field9) — float
- likes_count (Field10) — int
- keywords (Field11) — str
- user_attr (Field12) — str
- cdc_date (Field13) — date
- option (Field14) — str
v_trd_product (Untitled)
- id (Key) — str — Primary key — NOT NULL
- category_id (Key2) — str — Foreign key → v_trd_category.id — NOT NULL
- platform (Field) — str
- base_time (Field2) — datetime
- uid (Field3) — str
- brand (Field4) — str
- url (Field5) — str
- price (Field6) — int
- original_price (Field7) — int
- discount_price (Field8) — flot
- title (Field9) — str
- review_count (Field10) — int
- rate (Field11) — float
- reg_time (Field12) — datetime
- d_day (Field13) — int
- thumbnail_image (Field14) — str
- keywords (Field15) — str
- raw_ingredients (Field16) — str
- pre_ingredients (Field17) — str
- raw_manufacture (Field18) — str
- pre_manufacture (Field19) — str
- raw_manufacture_country (Field20) — str
- pre_manufacture_country (Field21) — str
- representation_manufacture_en (Field22) — str
- representation_manufacture_kr (Field23) — str
- representation_manufacture_org (Field24) — str
- representation_brnad_kr (Field25) — str
- representation_brnad_en (Field26) — str
- representation_brnad_org (Field27) — str
- cdc_date (Field28) — date
- dmstime_utc (Field29) — string
- representation_ingredients (Field30) — str
v_trd_sales_rank (Untitled3)
- id (Key) — Primary key — NOT NULL
- category_id (Key2) — str — Foreign key → v_trd_category.id — NOT NULL
- platform (Field) — str
- uid (Field2) — str
- rank (Field3) — int
- base_time (Field4) — date
- cdc_date (Field5) — date