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)