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