폰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)