폰ERD

테이블 (15)

Account (정산)

  • Key (ac_id) — int — 기본 키 — NOT NULL
  • Key (o_id) — int — 외래 키 → Order.Key — NOT NULL
  • Key (p_id) — int — 외래 키 → Order.Key — NOT NULL
  • Key (mall_id) — int — 외래 키 → Order.Key — NOT NULL
  • Key (p_id2) — int — 외래 키 → Order.Key — NOT NULL
  • Key (mall_id2) — int — 외래 키 → Order.Key — NOT NULL
  • Field (pay_give) — int
  • Field (pay_give2) — int
  • Field (pay_back) — int
  • Field (pay_back2) — int
  • Field (account_status) — varchar(20) — 정산대기 정산작업중 정산완료 환수대기 환수완료
  • Key (seq) — varchar(20) — 외래 키 → Dealing.Key — NOT NULL

Branch (대리점)

  • Key (Branch_id) — int — 기본 키 — NOT NULL — 기업 index
  • Field (Branch_email) — varchar(50) — NOT NULL — 기업 아이디
  • Field (Branch_name) — varchar(50)
  • Field (Branch_password) — varchar(50)
  • Field (Branch_status) — int — 활성:1 비활성:0
  • Field (Branch_tel) — int
  • Field (Branch_fax) — int
  • Field (Branch_owner) — varchar(50) — 대표자명
  • Field (Branch_pc) — varchar(50)
  • Field (Branch_pc_phon) — varchar(20)
  • Field (Branch_addr) — varchar(100)
  • Field (Branch_bank) — varchar(20)
  • Field (Branch_ah) — varchar(20) — 예금주
  • Field (Branch_bank_number)

Calling_plan (요금제)

  • Key (cp_id) — int — 기본 키 — NOT NULL
  • Key (c_id) — int — 외래 키 → Calling_plan_form.Key — NOT NULL
  • Field (cp_title) — varchar(50)
  • Field (cp_month_charge) — int
  • Field (cp_charge_info) — varchar(255)
  • Field (cp_sort) — int

Calling_plan_form (요금제형식)

  • Key (c_id) — int — 기본 키 — NOT NULL
  • Field (c_code) — varchar(20) — 요금제 형식 타이틀
  • Field (c_title) — varchar(30)

Card_discount (통신사 카드 할인)

  • Key (cd_id) — int — 기본 키 — NOT NULL
  • Key (t_id) — int — 외래 키 → Tell_company.Key — NOT NULL
  • Field (cd_name) — varchar(50)
  • Field (cd_discount) — int — 할인율
  • Field (cd_info) — varchar(100)

Dealing (접수처리)

  • Key (seq) — int — 기본 키 — NOT NULL
  • Key (o_id) — int — 외래 키 → Order.Key — NOT NULL
  • Key (p_id2) — int — 외래 키 → Order.Key — NOT NULL
  • Key (mall_id) — int — 외래 키 → Order.Key — NOT NULL
  • Key (p_id22) — int — 외래 키 → Order.Key — NOT NULL
  • Key (mall_id2) — int — 외래 키 → Order.Key — NOT NULL
  • Field (costumer) — varchar(20)
  • Field4 (open_date) — datetime
  • Field5 (ap_number) — varchar(50)
  • Field6 (usim_number) — varchar(30)
  • Field7 (memo) — varchar(100)
  • Field8 (memo2) — text
  • Key (Branch_id) — varchar(20) — 외래 키 → Branch.Key — NOT NULL — 기업 index
  • Field (progress) — varchar(20) — 방판접수대기 해피콜요청 해피콜완료 서식지대기 서식지완료 신조대기 신조정상 보류/관리 미개통배송중 개통요청 개통진행중 개통완료 접수취소 가망고객

Delivery (배송관리)

  • Key (d_id) — int — 기본 키 — NOT NULL
  • Key (o_id) — int — 외래 키 → Order.Key — NOT NULL
  • Key (p_id) — int — 외래 키 → Order.Key — NOT NULL
  • Key (mall_id) — int — 외래 키 → Order.Key — NOT NULL
  • Key (p_id2) — int — 외래 키 → Order.Key — NOT NULL
  • Key (mall_id2) — int — 외래 키 → Order.Key — NOT NULL
  • Field (receive) — varchar(50)
  • Field (addr1) — varchar(50)
  • Field (addr2) — varchar(100)
  • Field (request) — varchar(100)
  • Field (delivery_status) — varchar(20)
  • Field (delivery_date) — datetime
  • Field (post_company) — varchar(20)
  • Field (post_number) — int

Faq

  • Key (seq) — int — 기본 키 — NOT NULL
  • Field (cate) — int
  • Field (title) — varchar(100)
  • Field (content) — text
  • Field (sort) — int

Mall (방판몰)

  • Key (mall_id) — int — 기본 키 — NOT NULL
  • Key (p_id) — int — 외래 키 → Product.Key — NOT NULL
  • Key (mall_id2) — int — 외래 키 → Product.Key — NOT NULL
  • Field (mall_status) — int
  • Field (login_type) — int
  • Field (mall_title) — varchar(50) — 회사명
  • Field (mall_name) — varchar(50) — 방판몰 ID
  • Field (mall_url) — varchar(50) — 방판몰 주소
  • Field (mall_email) — varchar(50)
  • Field (mall_staff) — varchar(50) — 방판몰 엽업자
  • Field (mall_staff_hp) — varchar(50)
  • Field (login_id) — varchar(50)
  • Field (mall_gain) — int
  • Field (mall_cost) — int
  • Field (mall_logo) — varchar(100)
  • Field (mall_foot_info) — varchar(100)

Member (어플 회원관리)

  • Key (m_id) — int — 기본 키 — NOT NULL
  • Key (Branch_id) — int — 외래 키 → Branch.Key — NOT NULL — 기업 index
  • Field (mb_hp) — varchar(20)
  • Field (mb_name) — varchar(20)
  • Field (mb_password) — varchar(50)
  • Field (mb_email) — varcarh(50)
  • Field (mb_status) — int — 1:활성 0:비활성
  • Field (mb_agree) — int — 1:수신동의 0:수신거부
  • Field (mb_passport) — varchar(50)
  • Field (mb_info) — varchar(100)

Order (방판몰 주문)

  • Key (o_id) — int — 기본 키 — NOT NULL
  • Key (p_id) — int — 외래 키 → Product.Key — NOT NULL
  • Key (mall_id) — int — 외래 키 → Product.Key — NOT NULL
  • Key (p_id2) — int — 외래 키 → Product.Key — NOT NULL
  • Key (mall_id2) — int — 외래 키 → Product.Key — NOT NULL
  • Field (join_type) — int
  • Field (suport_type) — int
  • Field (color) — varchar(50)
  • Field (usim) — int
  • Field (open_type) — int
  • Field (pbi_type) — int — 0:할부금적용 1:할부그미적용
  • Field (contract) — varchar(100) — 약정개원
  • Field (installment) — int — 할부금 결제개원
  • Field
  • Key (cd_id) — int — 외래 키 → Card_discount.Key — NOT NULL
  • Key (t_id) — int — 외래 키 → Card_discount.Key — NOT NULL
  • Field2 (support_price) — int — 공시지원금
  • Field2 (discount_price) — int — 할부원금
  • Field2 (add_discount_price) — int
  • Field2 (oppen_price) — int
  • Field2 (product_price) — int
  • Field2 (default_price) — int
  • Field2 (installment_interest) — int
  • Field2 (select_installment) — int
  • Field2 (real_price) — int
  • Field2 (start_price) — int
  • Field2 (od_date) — datetime
  • Key (cp_id) — int — 외래 키 → Calling_plan.Key — NOT NULL
  • Key (c_id) — int — 외래 키 → Calling_plan.Key — NOT NULL

Product (방판몰 제품)

  • Key (p_id) — int — 기본 키 — NOT NULL
  • Key (mall_id) — int — 외래 키 → Mall.Key — NOT NULL
  • Key (p_id2) — int — 외래 키 → Mall.Key — NOT NULL
  • Key (mall_id2) — int — 외래 키 → Mall.Key — NOT NULL
  • Field (make) — varchar(50)
  • Field (product_name1) — varchar(50)
  • Field (product_name2) — varchar(50)
  • Field (product_number) — int
  • Field (price) — int — 출고가
  • Field (sort) — int
  • Field (color) — varchar(50)
  • Field (sale_status) — json — 판매현황 전체, 신규가입, 번호이동, 보상기변
  • Field (support_fund) — varchar(100) — 공시지원금
  • Field (product_img) — varchar(100)
  • Field (product_url) — varchar(100)
  • Field (p_date) — datetime
  • Key (t_id) — int — 외래 키 → Tell_company.Key — NOT NULL
  • Key (c_id) — int — 외래 키 → Calling_plan_form.Key — NOT NULL

Request_cable (유선 상담)

  • Key (re_id) — int — 기본 키 — NOT NULL
  • Field (name) — varchar(20)
  • Field (hp) — varchar(20)
  • Field (birth) — varchar(20)
  • Field (gender) — varchar(2)
  • Field (al_kind) — varchar(30)
  • Field (hope_kind) — varchar(30)
  • Field (etc1) — varchar(50)
  • Field (etc2) — varchar(50)
  • Field (etc3) — varchar(50)
  • Field (etc4) — varchar(50)
  • Field (req_info) — text
  • Field (status) — int — 1: 상담완료 0:상담전
  • Key (al_cp_id) — int — 외래 키 → Calling_plan.Key — NOT NULL
  • Key (hope_cp_id) — int — 외래 키 → Calling_plan.Key — NOT NULL

Staff (지사장/직원)

  • Key (staff_id) — int — 기본 키 — NOT NULL
  • Key (mall_id) — int — 외래 키 → Mall.Key — NOT NULL
  • Key (p_id) — int — 외래 키 → Mall.Key — NOT NULL
  • Key (mall_id2) — int — 외래 키 → Mall.Key — NOT NULL
  • Field (staff_level) — int
  • Field (staff_name) — varchar(50)
  • Field (staff_email) — varchar(50)
  • Field (staff_nick) — varchar(50)
  • Field (staff_password) — varchar(50)
  • Field (staff_hp) — varchar(50)
  • Field (staff_tel) — varchar(50)
  • Field (staff_addr) — varchar(100)
  • Field (Staff_birth) — varchar(50)

Tell_company (통신사)

  • Key (t_id) — int — 기본 키 — NOT NULL
  • Field (t_code) — varchar(50)
  • Field (t_title) — varchar(50)