wavbor

Tables (49)

additional_proposal (CopyOfUntitled31)

  • id (Key) — 수신자 — Primary key — NOT NULL
  • contact (Key3) — int — Foreign key → contact.id — NOT NULL
  • available_date (Field) — date
  • completion_date (Field2) — date
  • additional_amend_price (Field3) — int
  • is_pay_done (Field4) — bool

alarmtalk_log (Untitled)

  • id (Key) — int — Primary key — NOT NULL
  • to (Field) — str
  • template_code (Field2) — str
  • title (Field3) — str
  • content (Field4) — text
  • status (Field5) — str
  • fail_reason (Field6) — text

answer (Untitled10)

  • id (Key) — int — Primary key — NOT NULL
  • question (Key2) — int — Foreign key → question.id — NOT NULL
  • artist (Key3) — int — Foreign key → artist.id — NOT NULL
  • answer (Field) — text

artist (Untitled17)

  • id (Key) — int — Primary key — NOT NULL
  • user (Key2) — int — Foreign key → user.id — NOT NULL
  • nickname (Field) — str
  • profile (Field2) — image
  • introduction (Field3) — text
  • status (Field4) — str
  • country (Field5) — str
  • average_contact_time_start (Field6) — int
  • average_contact_time_end (Field7) — int
  • average_work_day (Field8) — str
  • average_price (Field9) — int
  • average_free_revision_num (Field10) — int
  • average_paid_edit_cost (Field11) — int
  • hit_1 (Field12) — int
  • hit_2 (Field13) — int
  • hit_3 (Field14) — int
  • hit_4 (Field15) — int
  • hit_5 (Field16) — int
  • hit_6 (Field17) — int
  • hit_7 (Field18) — int
  • hit_8 (Field19) — int
  • hit_9 (Field20) — int
  • hit_10 (Field21) — int
  • hit_11 (Field22) — int
  • hit_12 (Field23) — int
  • recommend_order (Field24) — int

artist_bank (Untitled24)

  • id (Key) — int — Primary key — NOT NULL
  • bank (Key3) — int — Foreign key → bank.id — NOT NULL
  • artist (Key2) — int — Foreign key → artist.id — NOT NULL
  • account_num (Field) — str
  • holder (Field2) — str

artist_instrument_price (Untitled22)

  • id (Key) — int — Primary key — NOT NULL
  • unit_price (Field) — int
  • work_day (Field2) — str
  • free_revision_num (Field3) — int
  • paid_edit_cost (Field4) — int
  • instrument (Key2) — int — Foreign key → tag.id — NOT NULL
  • artist (Key3) — int — Foreign key → artist.id — NOT NULL

artist_language (Untitled15)

  • id (Key) — int — Primary key — NOT NULL
  • name (Field) — str

artist_language_set (Untitled19)

  • id (Key) — int — Primary key — NOT NULL
  • artist (Key3) — int — Foreign key → artist.id — NOT NULL
  • artist_language (Key2) — int — Foreign key → artist_language.id — NOT NULL

artist_penalty_set (Untitled18)

  • id (Key) — int — Primary key — NOT NULL
  • artist (Key2) — int — Foreign key → artist.id — NOT NULL
  • penalty (Key3) — int — Foreign key → penalty.id — NOT NULL

artist_pro (Untitled27)

  • id (Key) — int — Primary key — NOT NULL
  • artist_switch_request (Key2) — int — Foreign key → artist_switch_request.id — NOT NULL
  • name (Field) — str
  • number (Field2) — str

artist_switch_request (Untitled26)

  • id (Key) — int — Primary key — NOT NULL
  • user (Key2) — int — Foreign key → user.id — NOT NULL
  • nickname (Field) — str
  • brief_history (Field2) — text
  • artist_type (Field3) — str
  • main_genre (Field4) — str
  • is_pro (Field5) — bool
  • link_1 (Field6) — url
  • link_2 (Field7) — url
  • link_3 (Field8) — url
  • is_judged (Field9) — bool
  • is_switch (Field10) — bool
  • is_rejected (Field11) — bool
  • reject_reason (Field12) — text

artist_tag_set (Untitled20)

  • id (Key) — int — Primary key — NOT NULL
  • tag (Key2) — int — Foreign key → tag.id — NOT NULL
  • artist (Key3) — int — Foreign key → artist.id — NOT NULL

bank (Untitled6)

  • id (Key) — int — Primary key — NOT NULL
  • bank_code_std (Field) — str
  • name (Field2) — str
  • icon (Field3) — image

chat (Untitled33)

  • id (Key) — int — Primary key — NOT NULL
  • contact (Key3) — int — Foreign key → contact.id — NOT NULL
  • user (Key2) — int — Foreign key → user.id — NOT NULL
  • artist (Key4) — int — Foreign key → user.id — NOT NULL
  • c_key (Field) — str
  • is_blocked (Field2) — bool

contact (Untitled28)

  • id (Key3) — int — Primary key — NOT NULL
  • user (Key) — int — Foreign key → user.id — NOT NULL
  • artist (Key2) — int — Foreign key → artist.id — NOT NULL
  • c_key (Field) — str
  • needs (Field2) — str
  • desired_completion_date (Field3) — date
  • completion_date (Field4) — date
  • usage (Field5) — str
  • usage_etc_reason (Field6) — str
  • other_publishing_rights_holder (Field7) — text
  • reference_project_detail (Field8) — text
  • status (Field9) — str

contact_audio (Untitled30)

  • id (Key) — int — Primary key — NOT NULL
  • contact (Key3) — int — Foreign key → contact.id — NOT NULL
  • audio (Field) — file

contact_cancel_reason (Untitled29)

  • id (Key) — int — Primary key — NOT NULL
  • contact (Key3) — int — Foreign key → contact.id — NOT NULL
  • cancel_reason (Field) — str
  • etc_reason (Field2) — str

contact_refund_reason (CopyOfCopyOfUntitled29)

  • id (Key) — int — Primary key — NOT NULL
  • contact (Key3) — int — Foreign key → contact.id — NOT NULL
  • refund_reason (Field) — str
  • etc_reason (Field2) — str

contact_reject_reason (CopyOfUntitled29)

  • id (Key) — int — Primary key — NOT NULL
  • contact (Key3) — int — Foreign key → contact.id — NOT NULL
  • reject_reason (Field) — str
  • etc_reason (Field2) — str

event (Untitled5)

  • id (Key) — int — Primary key — NOT NULL
  • name (Field) — str
  • detail (Field2) — text
  • is_active (Field3) — bool
  • start_date (Field4) — date
  • end_date (Field5) — date

event_user (Untitled34)

  • id (Key) — int — Primary key — NOT NULL
  • event (Key2) — int — Foreign key → event.id — NOT NULL
  • user (Key3) — int — Foreign key → user.id — NOT NULL

filmography (Untitled36)

  • id (Key) — int — Primary key — NOT NULL
  • artist (Key2) — int — Foreign key → artist.id — NOT NULL

filmography_image (Untitled37)

  • id (Key2) — int — Primary key — NOT NULL
  • filmography (Key) — int — Foreign key → filmography.id — NOT NULL
  • title (Field) — str
  • description (Field2) — text
  • image (Field3) — image

filmography_image_tag_set (Untitled38)

  • id (Key) — 수신자 — Primary key — NOT NULL
  • filmography_image (Key2) — int — Foreign key → filmography_image.id — NOT NULL
  • tag (Key3) — int — Foreign key → tag.id — NOT NULL

filmography_video (CopyOfUntitled37)

  • id (Key2) — int — Primary key — NOT NULL
  • filmography (Key) — int — Foreign key → filmography.id — NOT NULL
  • video (Field) — url
  • description (Field2) — text

filmography_video_tag_set (Untitled39)

  • id (Key) — int — Primary key — NOT NULL
  • filmography_video (Key2) — int — Foreign key → filmography_video.id — NOT NULL
  • tag (Key3) — int — Foreign key → tag.id — NOT NULL

follow (Untitled23)

  • id (Key) — int — Primary key — NOT NULL
  • follower (Key2) — int — Foreign key → user.id — NOT NULL
  • followee (Key3) — int — Foreign key → artist.id — NOT NULL

main_banner (Untitled2)

  • id (Key) — int — Primary key — NOT NULL
  • event (Key2) — int — Foreign key → event.id — NOT NULL
  • banner_type (Field2) — str
  • kind (Field) — str
  • title (Field3) — str
  • sub_title (Field4) — str
  • image (Field5) — image
  • order (Field6) — int
  • is_active (Field7) — bool
  • start_date (Field8) — date
  • end_date (Field9) — date

main_banner_button (Untitled3)

  • id (Key) — int — Primary key — NOT NULL
  • main_banner (Key2) — int — Foreign key → main_banner.id — NOT NULL
  • text (Field) — str
  • link (Field2) — url
  • order (Field3) — int

message (Untitled40)

  • id (Key) — int — Primary key — NOT NULL
  • chat (Key3) — int — Foreign key → chat.id — NOT NULL
  • user (Key2) — int — Foreign key → user.id — NOT NULL
  • type (Field) — str
  • text (Field2) — text
  • image (Field3) — image
  • file (Field4) — file
  • audio (Field5) — file
  • is_user_only (Field6) — bool
  • is_artist_only (Field7) — bool
  • is_user_read (Field8) — bool
  • is_artist_read (Field9) — bool

music_product_team (Untitled7)

  • id (Key) — int — Primary key — NOT NULL
  • name (Field) — str
  • video (Field2) — url
  • order (Field3) — int

nice_crypt_info (Untitled25)

  • id (Key) — int — Primary key — NOT NULL
  • requestno (Field) — str
  • token_version_id (Field2) — str
  • key (Field3) — str
  • iv (Field4) — str

partner_company (Untitled8)

  • id (Key) — int — Primary key — NOT NULL
  • company_name (Field) — str
  • image (Field2) — image
  • order (Field3) — int

payment (Untitled41)

  • id (Key) — int — Primary key — NOT NULL
  • contact (Key3) — int — Foreign key → contact.id — NOT NULL
  • proposal (Key2) — int — Foreign key → proposal.id — NOT NULL
  • additional_proposal (Key4) — int — Foreign key → additional_proposal.id — NOT NULL
  • tid (Field) — str
  • cancelled_tid (Field2) — str
  • order_id (Field3) — str
  • status (Field4) — str
  • pay_method (Field5) — str
  • goods_name (Field6) — str
  • channel (Field7) — str
  • currency (Field8) — str
  • total_amount (Field9) — int
  • settle_available_amount (Field10) — int
  • refund_amount (Field11) — int
  • receipt_url (Field12) — str
  • paid_at (Field13) — datetime
  • failed_at (Field14) — datetime
  • cancelled_at (Field15) — datetime
  • origin_response (Field16) — json

payment_webhook_history (Untitled42)

  • id (Key) — int — Primary key — NOT NULL
  • payment (Key2) — int — Foreign key → payment.id — NOT NULL
  • status (Field) — str
  • webhook (Field2) — json

penalty (Untitled11)

  • id (Key) — int — Primary key — NOT NULL
  • type (Field) — str
  • name (Field2) — str
  • detail (Field3) — str

proposal (Untitled31)

  • id (Key) — 수신자 — Primary key — NOT NULL
  • contact (Key3) — int — Foreign key → contact.id — NOT NULL
  • available_days (Field) — int
  • completion_days (Field2) — int
  • available_date (Field3) — date
  • completion_date (Field4) — date
  • free_revision_num (Field5) — int
  • price_per_paid_revision (Field6) — int
  • total_price (Field7) — int
  • is_readable (Field8) — bool

publication_right_data_request (Untitled32)

  • id (Key) — int — Primary key — NOT NULL
  • contact (Key3) — int — Foreign key → contact.id — NOT NULL
  • requester_email (Field) — email
  • detail (Field3) — text
  • is_done (Field2) — bool

question (Untitled9)

  • id (Key) — int — Primary key — NOT NULL
  • query (Field) — str
  • placeholder (Field2) — str

refund_request (Untitled44)

  • id (Key) — int — Primary key — NOT NULL
  • chat (Key2) — int — Foreign key → chat.id — NOT NULL
  • payment (Key3) — int — Foreign key → payment.id — NOT NULL
  • request_type (Field) — str
  • contact_last_updated_at (Field2) — datetime
  • contact_completion_date (Field3) — date
  • refund_available_amount (Field4) — int
  • refund_amount (Field5) — int
  • is_refund (Field6) — bool
  • is_in_refund_progress (Field7) — bool
  • is_create_settlement (Field8) — bool
  • refund_reason (Field9) — str
  • etc_reason (Field10) — text

register_event_participant (Untitled35)

  • id (Key) — int — Primary key — NOT NULL
  • event_user (Key2) — int — Foreign key → event_user.id — NOT NULL
  • order_id (Field) — str
  • name (Field2) — str
  • phone (Field3) — str
  • cashback (Field4) — int
  • account_num (Field5) — str
  • bank_name (Field6) — str
  • is_user_participated (Field7) — bool
  • is_artist_participated (Field8) — bool
  • is_rewarded (Field9) — bool

review (Untitled45)

  • id (Key) — int — Primary key — NOT NULL
  • contact (Key3) — int — Foreign key → contact.id — NOT NULL
  • star (Field) — int
  • content (Field2) — text

search_banner (Untitled4)

  • id (Key) — int — Primary key — NOT NULL
  • banner_type (Field) — str
  • image (Field2) — image
  • is_active (Field3) — bool

settlement (Untitled43)

  • id (Key) — int — Primary key — NOT NULL
  • payment (Key2) — int — Foreign key → payment.id — NOT NULL
  • artist (Key3) — int — Foreign key → artist.id — NOT NULL
  • total_amount (Field) — int
  • refund_amount (Field2) — int
  • settle_available_amount (Field3) — int
  • service_usage_fee (Field4) — int
  • commission (Field5) — int
  • vat (Field6) — int
  • total_fee (Field7) — int
  • settlement_amount (Field8) — int
  • settlement_date (Field9) — date
  • status (Field10) — str

social (Untitled14)

  • id (Key) — int — Primary key — NOT NULL
  • kind (Field) — str
  • user (Key2) — int — Foreign key → user.id — NOT NULL

tag (Untitled12)

  • id (Key) — int — Primary key — NOT NULL
  • type (Field) — str
  • name (Field2) — str

user (Untitled13)

  • id (Key) — int — Primary key — NOT NULL
  • name (Field) — str
  • email (Field2) — email
  • phone (Field3) — str
  • social_email (Field4) — str
  • profile (Field5) — image
  • ex_name (Field6) — str
  • is_staff (Field7) — bool
  • is_superuser (Field8) — bool
  • is_active (Field9) — bool
  • date_joined (Field10) — datetime
  • is_kakao_info_agree (Field11) — bool
  • is_sms_info_agree (Field12) — bool
  • is_email_info_agree (Field13) — bool
  • is_kakao_contact_agree (Field14) — bool
  • is_swtich_request (Field15) — bool
  • is_switch_confirm (Field16) — bool
  • is_artist (Field17) — bool
  • view (Field18) — str

user_artist_hit (Untitled21)

  • id (Key) — int — Primary key — NOT NULL
  • user (Key2) — int — Foreign key → user.id — NOT NULL
  • artist (Key3) — int — Foreign key → artist.id — NOT NULL

user_penalty_set (Untitled16)

  • id (Key) — int — Primary key — NOT NULL
  • user (Key2) — int — Foreign key → user.id — NOT NULL
  • penalty (Key3) — int — Foreign key → penalty.id — NOT NULL