ziple

Tables (13)

banner (Untitled3)

  • banner_no (Key) — Primary key — NOT NULL
  • banner_url (Field)
  • banner_link (Field2)
  • show_yn (Field3)

del_company (Untitled2)

  • company_no (Key) — Primary key — NOT NULL
  • company_name (Field)
  • company_addr (Field2)
  • company_addr_x (Field3)
  • company_addr_y (Field4)
  • company_bio (Field5)
  • company_email (Field6)
  • company_tel (Field7)

delegate_advert (대리인 광고관련)

  • ad_no (Key) — Primary key — NOT NULL
  • user_no (Field)
  • delegate_user_no (Field2)
  • contents (Field3)
  • delegate_yn (Field4)
  • createdAt (Field5)
  • updatedAt (Field6)
  • ad_grade (Field7)
  • ad_start_date (Field8)
  • ad_end_date (Field9)

delegate_info (Untitled)

  • info_no (Key) — Primary key — NOT NULL
  • user_no (Field)
  • delegate_user_no (Field2)
  • user_email (Field3)
  • phone_no (Field4)
  • profile_url (Field5)
  • company_nm (Field6)
  • kakao_info (Field7)
  • site_url (Field8)
  • createdAt (Field9)
  • updatedAt (Field10)
  • deletedAt (Field11)
  • kakaoYn (Field12)
  • faUrl (Field13)
  • insUrl (Field14)
  • delegate_career (Field15)
  • delegate_record (Field16)
  • company_id (Field17)
  • is_represent (Field18)

faq (자주묻는질문)

  • faq_no (Key) — Primary key — NOT NULL
  • title (Field)
  • contents (Field2)
  • category (Field3)
  • is_show (Field4)
  • createdAt (Field5)

idea (Untitled4)

  • idea_no (Key) — Primary key — NOT NULL
  • title (Field)
  • contents (Field2)
  • category (Field3)
  • publish_num (Field4)
  • reg_date (Field5)
  • price_start (Field6)
  • price_end (Field7)
  • status (Field8)

idea_join (Untitled5)

  • idea_join_no (Key) — Primary key — NOT NULL
  • idea_no (Field)
  • user_no (Field2)
  • auth_user_no (Field3)
  • createdAt (Field4)
  • is_choice (Field5)

idea_reply (Untitled6)

  • idea_reply_no (Key) — Primary key — NOT NULL
  • idea_no (Field)
  • contents (Field2)
  • user_no (Field3)
  • createdAt (Field4)

push_hist (푸쉬이력)

  • push_no (Key) — Primary key — NOT NULL
  • user_no (Field2)
  • contents (Field3)
  • ref_div (Field4)
  • ref_key (Field5)
  • read_yn (Field6)
  • reg_date (Field7)

qna (큐엔에이)

  • qna_no (Key) — Primary key — NOT NULL
  • title (Field)
  • contents (Field2)
  • category (Field3)
  • cretedAt (Field4)
  • updatedAt (Field5)
  • deletedAt (Field6)

qna_reply (큐엔에이 답변)

  • qna_no (Key) — Primary key — NOT NULL
  • contents (Field)
  • author (Field2)
  • createdAt (Field3)

user (유저)

  • user_no (Key) — Primary key — NOT NULL
  • user_email (Field)
  • password (Field2)
  • user_nm (Field3)
  • nick_nm (Field4)
  • phone_no (Field5)
  • user_div_cd (Field6)
  • profile_url (Field7)
  • token (Field8)
  • join_path (Field9)
  • sns_id (Field10)
  • is_admin (Field11)
  • createdAt (Field12)
  • updatedAt (Field13)
  • deletedAt (Field14)

user_push (유저푸쉬)

  • user_push_no (Key) — Primary key — NOT NULL
  • my_idea (Field)
  • my_chatbot (Field2)
  • my_qna (Field3)
  • info_up (Field4)
  • my_idea_status (Field5)
  • user_no (Field6)