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