vod service

Tables (10)

Imagesource

  • Key (id) — Primary key — NOT NULL
  • id (course_id) — bigint — Foreign key → class.id — NOT NULL
  • Field (source_type)
  • Field2 (source_url)

account_info (Untitled3)

  • Key — Primary key — NOT NULL

class (강좌)

  • id — bigint — Primary key — NOT NULL
  • title (강좌명) — str
  • origin_price (강좌가격) — int
  • discount_price (할인가) — int
  • is_discount (할인여부) — bool
  • update (등록일) — date
  • play_url (강좌url) — url
  • thumbnail (썸네일) — url

contest (Untitled)

  • Key — Primary key — NOT NULL
  • start (Field)
  • end (Field2)
  • 1st_prize (Field3)
  • 2nd_prize (Field4)

contest_user (Untitled2)

  • Key — Primary key — NOT NULL
  • Key (Key2) — Foreign key → account_info.Key — NOT NULL
  • Key (Key3) — Foreign key → contest.Key — NOT NULL
  • participate_date (Field)
  • 대회수익률 (Field2)

lecture (강의)

  • id — bigint — Primary key — NOT NULL
  • class_id — bigint — Foreign key → class.id — NOT NULL
  • chapter (챕터) — int
  • course (강의) — int
  • title (강의명) — str
  • url (강의주소) — url
  • thumbmail (썸네일) — url

purcahse_history (구매내역)

  • id — bigint — Primary key — NOT NULL
  • uid (user_id) — bigint — Foreign key → quantus_user.id — NOT NULL
  • recommender_id (추천인 코드) — bigint — Foreign key → quantus_user_recommenders.id — NOT NULL
  • class_id — bigint — Foreign key → class.id — NOT NULL
  • purchase_date (구매날짜) — date
  • price (구매가격) — int
  • purchase_type (구매종류) — str

quantus_user

  • id — bigint — Primary key — NOT NULL
  • sns_id — varchar(1000)
  • sns_type — varchar(100)
  • email — varchar(100)
  • nickname — varchar(100)
  • created_at — timestamp
  • level — varchar(100)
  • is_competing — tinyint(1)
  • push_token — text
  • is_opt_out — tinyint
  • magic_split_issued — tinyint(1)
  • signup_platform — varchar(100)
  • is_relationship — tinyint(1)
  • coupon_issued — tinyint(1)
  • is_vip — tinyint(1)
  • vip_start_date — datetime
  • vip_end_date — datetime

quantus_user_recommenders

  • id — bigint — Primary key — NOT NULL
  • created_at — datetime
  • updated_at — datetime
  • uid — int — NOT NULL
  • recommender_id — varchar(100)
  • self_rate — float
  • buyer_rate — float
  • is_ambassador — tinyint(1)
  • discount_rate — float

review (리뷰)

  • id — bigint — Primary key — NOT NULL
  • uid — bigint — Foreign key → quantus_user.id — NOT NULL
  • class_id — bigint — Foreign key → class.id — NOT NULL
  • title (리뷰명) — str
  • content (Field) — str
  • create_date (작성일) — date
  • update_date (수정일) — date
  • favorite_rate (별점) — float