tongdoc_ERD_1.0.1
Tables (31)
admin
- id — bigint(20) — Primary key — NOT NULL
- name — varchar(255) — NOT NULL — 관리자 이름
- email — varchar(255) — NOT NULL — 관리자 계정
- password — varchar(255) — NOT NULL — 관리자 패스워드
- role — int(11) — NOT NULL — 관리자 권한등급
- remember_token — varchar(100) — 로그인 유지 토큰
- created_at — timestamp
- updated_at — timestamp
- deleted_at — timestamp
- created_by — varchar(255)
- updated_by — varchar(255)
- deleted_by — varchar(255)
- created_ip — varchar(255)
- updated_ip — varchar(255)
- deleted_ip — varchar(255)
agent
- id — bigint(20) — Primary key — NOT NULL
- account — varchar(255) — NOT NULL — 대리점 계정
- name — varchar(255) — NOT NULL — 대리점 이름
- password — varchar(255) — NOT NULL — 대리점 패스워드
- agent_point — varchar(255) — NOT NULL — 대리점 포인트
- loc1 — varchar(255) — NOT NULL — 대리점 주소(시/도)
- loc2 — varchar(255) — NOT NULL — 대리점 주소(구/군)
- loc3 — varchar(255) — NOT NULL — 대리점 주소(동/읍/면)
- loc4 — varchar(255) — NOT NULL — 대리점 주소(상세 주소)
- email — varchar(255) — NOT NULL — 대리점 이메일
- phone_number — varchar(255) — NOT NULL — 대리점 연락처
- license — varchar(255) — NOT NULL — 대리점 사업자등록번호
- license_picture — varchar(255) — NOT NULL — 대리점 사업자등록번호 사진
- introduce — varchar(255) — 대리점 소개
- approval — int(11) — 대리점 승인 여부
- approval_admin — varchar(255) — 대리점 승인 결정 관리자 ID
- approval_at — timestamp — 대리점 승인 날짜
- grade — int(11) — NOT NULL — 대리점 등급
- stop — tinyint(4) — NOT NULL — 대리점 정지 여부
- created_at — timestamp
- updated_at — timestamp
- deleted_at — timestamp
- created_by — varchar(255)
- updated_by — varchar(255)
- deleted_by — varchar(255)
- created_ip — varchar(255)
- updated_ip — varchar(255)
- deleted_ip — varchar(255)
auction
- id — bigint(20) — Primary key — NOT NULL
- user_id — int(11) — NOT NULL — 구매요청 작성 회원ID
- fam_id — int(11) — 구매 희망 가족 ID
- new_id — int(11) — 신규 구매 희망자 ID
- buyer_name — varchar(50) — NOT NULL — 구매 희망자(실 구매자) 이름
- plan_id — int(11) — NOT NULL — 요금제 ID
- phone_id — int(11) — NOT NULL — 휴대폰 ID
- sale_type — int(11) — NOT NULL — 할인 종류(0:공시지원,1:선택약정)
- telecom — varchar(255) — NOT NULL — 통신사
- phone_state — varchar(255) — NOT NULL — 휴대폰 통신사 변경 여부(0:기기변경,1:번호이동)
- internet_state — varchar(255) — NOT NULL — 인터넷 통신사 변경 여부(0:인터넷 유지,1:인터넷 변경)
- loc_1_1 — varchar(255) — 구매 지역 1(시/도)
- loc_1_2 — varchar(255) — 구매 지역 1(구/군)
- loc_1_3 — varchar(255) — 구매 지역 1(동/읍/면)
- loc_2_1 — varchar(255) — 구매 지역 2(시/도)
- loc_2_2 — varchar(255) — 구매 지역 2(구/군)
- loc_2_3 — varchar(255) — 구매 지역 2(동/읍/면)
- offer_cnt — int(11) — 받은 제안 수
- reserve_id — int(11) — 예약 ID
- confirm_state — tinyint(4) — 구매 확정 여부
- confirm_at — timestamp — 구매 확정 날짜
- created_at — timestamp
- updated_at — timestamp
- deleted_at — timestamp
- created_by — varchar(255)
- updated_by — varchar(255)
- deleted_by — varchar(255)
- created_ip — varchar(255)
- updated_ip — varchar(255)
- deleted_ip — varchar(255)
buy_coment
- id — bigint(20) — Primary key — NOT NULL
- division — varchar(255) — NOT NULL — 코멘트 구분(인터넷,휴대폰)
- tcom — tinyint(4) — NOT NULL — 휴대폰 여부
- icom — tinyint(4) — NOT NULL — 인터넷 여부
- promiseW — tinyint(4) — 휴대폰 약정 여부
- ipromiseW — tinyint(4) — 인터넷 약정 여부
- promiseR — tinyint(4) — 통신사 변경 여부
- combine — tinyint(4) — 결합 할인 여부
- coment — varchar(255) — NOT NULL — 코멘트
- created_at — timestamp
- updated_at — timestamp
- deleted_at — timestamp
- created_by — varchar(255)
- updated_by — varchar(255)
- deleted_by — varchar(255)
- created_ip — varchar(255)
- updated_ip — varchar(255)
- deleted_ip — varchar(255)
buy_new
- id — bigint(20) — Primary key — NOT NULL
- user_id — int(11) — NOT NULL — 신규 가입 희망자 등록 회원 ID
- new_name — varchar(255) — NOT NULL — 신규 가입 희망자 이름
- new_birth — varchar(255) — NOT NULL — 신규 가입 희망자 생년월일
- created_at — timestamp
- updated_at — timestamp
- deleted_at — timestamp
- created_by — varchar(255) — NOT NULL
- updated_by — varchar(255) — NOT NULL
- delete_by — varchar(255) — NOT NULL
- created_ip — varchar(255) — NOT NULL
- updated_ip — varchar(255) — NOT NULL
- deleted_ip — varchar(255) — NOT NULL
failed_jobs
- id — bigint(20) — Primary key — NOT NULL
- connection — text — NOT NULL
- queue — text — NOT NULL
- payload — longtext — NOT NULL
- exception — longtext — NOT NULL
- failed_at — timestamp — NOT NULL
internet_bill
- id — bigint(20) — Primary key — NOT NULL
- check_y — varchar(255) — NOT NULL — 청구서 년도
- check_m — varchar(255) — NOT NULL — 청구서 월
- user_id — int(11) — NOT NULL — 회원 ID
- phone_number — varchar(255) — NOT NULL — 회원 휴대폰 번호
- telecom — varchar(255) — NOT NULL — 회원 통신사
- charge — int(11) — 청구 금액(총)
- base_price — int(11) — 인터넷 기본료
- vas_price — int(11) — 인터넷 부가 서비스
- sale_price — int(11) — 인터넷 약정 할인
- join_sale — int(11) — 인터넷 결합 할인
- tv_base_price — int(11) — tv 기본료
- tv_contents_price — int(11) — tv 부가서비스(컨텐츠 이용료)
- tv_sale_price — int(11) — tv 약정 할인
- tv_join_sale — int(11) — tv 결합 할인
- smart_price — int(11) — smart홈 기기 사용료
- smart_sale — int(11) — smart홈 할인
- etc_sale — int(11) — 기타 할인
- vat_price — int(11) — 부가가치세
- promise_at — timestamp — 약정 날짜
- promise_end — timestamp — 약정 만료 날짜
- check_state — int(11) — NOT NULL — 최근 데이터 업데이트(등록) 여부
- created_at — timestamp
- updated_at — timestamp
- deleted_at — timestamp
- created_by — varchar(255)
- updated_by — varchar(255)
- deleted_by — varchar(255)
- created_ip — varchar(255)
- updated_ip — varchar(255)
- deleted_ip — varchar(255)
internet_bill_log
- id — bigint(20) — Primary key — NOT NULL
- source_id — int(11) — NOT NULL
- check_y — varchar(255) — NOT NULL
- check_m — varchar(255) — NOT NULL
- user_id — int(11) — NOT NULL
- phone_number — varchar(255) — NOT NULL
- telecom — varchar(255) — NOT NULL
- charge — int(11)
- base_price — int(11)
- vas_price — int(11)
- tv_base_price — int(11)
- tv_contents_price — int(11)
- smart_price — int(11)
- join_sale — int(11)
- etc_sale — int(11)
- vat_price — int(11)
- promise_at — timestamp
- promise_end — timestamp
- created_at — timestamp
- updated_at — timestamp
- deleted_at — timestamp
- created_by — varchar(255)
- updated_by — varchar(255)
- deleted_by — varchar(255)
- created_ip — varchar(255)
- updated_ip — varchar(255)
- deleted_ip — varchar(255)
internet_family
- id — bigint(20) — Primary key — NOT NULL
- user_id — int(11) — NOT NULL — 회원 ID
- fam_id — int(11) — 가족회원 ID
- pn_id — int(11) — 휴대폰 번호 ID
- fam_name — varchar(255) — NOT NULL — 가족 이름
- fam_phone_number — varchar(255) — NOT NULL — 가족 휴대폰 번호
- fam_telecom — varchar(255) — NOT NULL — 가족 통신사
- fam_state — int(11) — NOT NULL — 상태(수락/거절)
- created_at — timestamp
- updated_at — timestamp
- deleted_at — timestamp
- created_by — varchar(255)
- updated_by — varchar(255)
- deleted_by — varchar(255)
- created_ip — varchar(255)
- updated_ip — varchar(255)
- deleted_ip — varchar(255)
jwt_access_token
- id — bigint(20) — Primary key — NOT NULL
- user_id — int(11) — NOT NULL
- token — varchar(255) — NOT NULL
- revoke — tinyint(4) — NOT NULL
- expires_in — timestamp — NOT NULL
- created_at — timestamp
- updated_at — timestamp
- deleted_at — timestamp
jwt_refresh_token
- id — bigint(20) — Primary key — NOT NULL
- user_id — int(11) — NOT NULL
- token — varchar(255) — NOT NULL
- revoke — tinyint(4) — NOT NULL
- expires_in — timestamp — NOT NULL
- created_at — timestamp
- updated_at — timestamp
- deleted_at — timestamp
migrations
- id — int(10) — Primary key — NOT NULL
- migration — varchar(255) — NOT NULL
- batch — int(11) — NOT NULL
notice
- id — bigint(20) — Primary key — NOT NULL
- user_id — int(11) — NOT NULL — 회원 ID(알림의 소유자)
- target_id — int(11) — NOT NULL — 알림 발생 회원 ID
- source_id — int(11) — NOT NULL — 이벤트 발생 근원지 ID
- notice_type — varchar(255) — NOT NULL — 알림 종류
- notice_subject — varchar(255) — NOT NULL — 알림 제목
- notice_message — varchar(255) — NOT NULL — 알림 내용
- notice_url — varchar(255) — NOT NULL — 알림 이동 URL
- check_at — timestamp — 알림 확인 여부
- created_at — timestamp
- updated_at — timestamp
- deleted_at — timestamp
- created_by — varchar(255)
- updated_by — varchar(255)
- deleted_by — varchar(255)
- created_ip — varchar(255)
- updated_ip — varchar(255)
- deleted_ip — varchar(255)
oauth_access_tokens
- id — varchar(100) — Primary key — NOT NULL
- user_id — bigint(20)
- client_id — bigint(20) — NOT NULL
- name — varchar(255)
- scopes — text
- revoked — tinyint(1) — NOT NULL
- created_at — timestamp
- updated_at — timestamp
- expires_at — datetime
oauth_auth_codes
- id — varchar(100) — Primary key — NOT NULL
- user_id — bigint(20) — NOT NULL
- client_id — bigint(20) — NOT NULL
- scopes — text
- revoked — tinyint(1) — NOT NULL
- expires_at — datetime
oauth_clients
- id — bigint(20) — Primary key — NOT NULL
- user_id — bigint(20)
- name — varchar(255) — NOT NULL
- secret — varchar(100)
- provider — varchar(255)
- redirect — text — NOT NULL
- personal_access_client — tinyint(1) — NOT NULL
- password_client — tinyint(1) — NOT NULL
- revoked — tinyint(1) — NOT NULL
- created_at — timestamp
- updated_at — timestamp
oauth_personal_access_clients
- id — bigint(20) — Primary key — NOT NULL
- client_id — bigint(20) — NOT NULL
- created_at — timestamp
- updated_at — timestamp
oauth_refresh_tokens
- id — varchar(100) — Primary key — NOT NULL
- access_token_id — varchar(100) — NOT NULL
- revoked — tinyint(1) — NOT NULL
- expires_at — datetime
offer
- id — bigint(20) — Primary key — NOT NULL
- sugguest — bigint(20) — 제안 번호
- auct_id — int(11) — NOT NULL — 구매 요청 ID
- agent_id — int(11) — NOT NULL — 제안 대리점 ID
- phone_id — int(11) — NOT NULL — 휴대폰 ID
- sale_type — tinyint(4) — NOT NULL — 할인 종류(0:공시지원,1:선택약정)
- telecom — varchar(255) — NOT NULL — 통신사
- plan_id — int(11) — NOT NULL — 요금제 ID
- bill_price — int(11) — NOT NULL — 월 통신비
- device_price — int(11) — NOT NULL — 월 단말기 할부금
- device_vat — int(11) — NOT NULL — 월 단말기 할부금 부가가치세
- offer_price — int(11) — NOT NULL — 오퍼금액
- offer_contents — longtext — NOT NULL — 오퍼 내용
- confirm_state — tinyint(4) — NOT NULL — 구매 확정 여부
- confirm_at — timestamp — 구매 확정 날짜
- validate_offer — tinyint(4) — NOT NULL — 제안 유효 여부
- created_at — timestamp
- updated_at — timestamp
- deleted_at — timestamp
- created_by — varchar(255)
- updated_by — varchar(255)
- deleted_by — varchar(255)
- created_ip — varchar(255)
- updated_ip — varchar(255)
- deleted_ip — varchar(255)
password_resets
- email — varchar(255) — NOT NULL
- token — varchar(255) — NOT NULL
- created_at — timestamp
phone
- id — bigint(20) — Primary key — NOT NULL
- phone_name — varchar(255) — NOT NULL — 휴대폰 이름
- phone_model — varchar(255) — NOT NULL — 모델명
- telecom — varchar(255) — 통신사
- phone_produce — varchar(255) — NOT NULL — 제조사
- service_type — varchar(255) — NOT NULL — 이동통신망(1:LTE, 2:3G, 3:5G
- phone_grade — tinyint(4) — NOT NULL — 휴대폰 등급(최신 고급형, 보급형)
- phone_storage — varchar(255) — NOT NULL — 용량
- phone_price — int(11) — NOT NULL — 출고가
- start_at — timestamp — 출고 날짜
- stop_at — timestamp — 판매 중지 날짜
- memo — varchar(255) — 기타 메모
- created_at — timestamp
- updated_at — timestamp
- deleted_at — timestamp
- created_by — varchar(255)
- updated_by — varchar(255)
- deleted_by — varchar(255)
- created_ip — varchar(255)
- updated_ip — varchar(255)
- deleted_ip — varchar(255)
phone_bill
- id — bigint(20) — Primary key — NOT NULL
- check_y — varchar(255) — NOT NULL — 청구 년도
- check_m — varchar(255) — NOT NULL — 청구 월
- user_id — int(11) — NOT NULL — 회원 ID
- phone_number — varchar(255) — NOT NULL — 휴대폰번호
- telecom — varchar(255) — NOT NULL — 통신사
- plan_id — int(11) — 요금제 ID
- plan_type — int(11) — NOT NULL — 이동통신망(1:LTE, 2:3G, 3:5G
- charge — int(11) — 청구 금액
- plan_price — int(11) — 월 정액 요금
- data_price — int(11) — 추가 데이터 사용 요금
- add_price — int(11) — 추가 사용료(통화/문자)
- etc_price — int(11) — 기타 추가 사용료
- vas_price — int(11) — 부가서비스
- pay_price — int(11) — 소액결제
- device_price — int(11) — 단말기 할부금
- join_sale — int(11) — 결합할인금액
- plan_sale — int(11) — 선택약정 할인 금액
- etc_sale — int(11) — 기타 할인 금액
- cut_sale — int(11) — 10원미만할인
- vat_price — int(11) — 부가가치세
- use_data — int(11) — 데이터 사용량(당월)
- avg_data — int(11) — 데이터 사용량(3개월 평균)
- promise_month — int(11) — 약정 기간(12,24)
- promise_at — timestamp — 약정 가입 날짜
- check_state — int(11) — NOT NULL — 당월 업데이트 여부
- created_at — timestamp
- updated_at — timestamp
- deleted_at — timestamp
- created_by — varchar(255)
- updated_by — varchar(255)
- deleted_by — varchar(255)
- created_ip — varchar(255)
- updated_ip — varchar(255)
- deleted_ip — varchar(255)
phone_bill_log
- id — bigint(20) — Primary key — NOT NULL
- source_id — int(11) — NOT NULL
- check_y — varchar(255) — NOT NULL
- check_m — varchar(255) — NOT NULL
- user_id — int(11) — NOT NULL
- phone_number — varchar(255) — NOT NULL
- telecom — varchar(255) — NOT NULL
- plan_id — int(11)
- plan_type — int(11) — NOT NULL
- charge — int(11)
- plan_price — int(11)
- data_price — int(11)
- add_price — int(11)
- etc_price — int(11)
- vas_price — int(11)
- pay_price — int(11)
- device_price — int(11)
- join_sale — int(11)
- plan_sale — int(11)
- etc_sale — int(11)
- cut_sale — int(11)
- vat_price — int(11)
- use_data — int(11)
- avg_data — int(11)
- promise_month — int(11)
- promise_at — timestamp
- created_at — timestamp
- updated_at — timestamp
- deleted_at — timestamp
- created_by — varchar(255)
- updated_by — varchar(255)
- deleted_by — varchar(255)
- created_ip — varchar(255)
- updated_ip — varchar(255)
- deleted_ip — varchar(255)
phone_family
- id — bigint(20) — Primary key — NOT NULL
- user_id — int(11) — NOT NULL — 회원 ID
- fam_id — int(11) — 가족 회원 ID
- pn_id — int(11) — 가족 회원 휴대폰 번호 ID
- fam_name — varchar(255) — NOT NULL — 가족 회원 이름
- fam_phone_number — varchar(255) — NOT NULL — 가족 회원 휴대폰 번호
- fam_telecom — varchar(255) — NOT NULL — 가족 회원 통신사
- fam_state — int(11) — NOT NULL — 가족 상태(수락/거절)
- created_at — timestamp
- updated_at — timestamp
- deleted_at — timestamp
- created_by — varchar(255)
- updated_by — varchar(255)
- deleted_by — varchar(255)
- created_ip — varchar(255)
- updated_ip — varchar(255)
- deleted_ip — varchar(255)
phone_img
- id — bigint(20) — Primary key — NOT NULL
- phone_id — int(11) — NOT NULL
- img — varchar(255) — NOT NULL
- detail_img — varchar(255) — NOT NULL
- created_at — timestamp
- updated_at — timestamp
- deleted_at — timestamp
phone_number
- id — bigint(20) — Primary key — NOT NULL
- phone_number — varchar(255) — NOT NULL — 휴대폰 번호
- user_id — varchar(255) — NOT NULL — 회원 ID
- telecom — varchar(255) — NOT NULL — 통신사
- created_at — timestamp
- updated_at — timestamp
- deleted_at — timestamp
- created_by — varchar(255)
- updated_by — varchar(255)
- deleted_by — varchar(255)
- created_ip — varchar(255)
- updated_ip — varchar(255)
- deleted_ip — varchar(255)
plan
- id — bigint(20) — Primary key — NOT NULL
- plan_name — varchar(255) — NOT NULL — 요금제 이름
- plan_price — int(11) — NOT NULL — 요금제 금액
- telecom — varchar(255) — NOT NULL — 통신사
- plan_type — int(11) — NOT NULL — 이동통신망(1:LTE, 2:3G, 3:5G
- plan_grade — tinyint(4) — 요금제 등급
- data — int(11) — 기본 제공 데이터
- voice — int(11) — 기본 제공 음성
- age — int(11) — 연령제한
- plan_link — varchar(255) — 해당 요금제 링크
- start_at — timestamp — 요금제 시작 날짜
- stop_at — timestamp — 요금제 중지 날짜
- created_at — timestamp
- updated_at — timestamp
- deleted_at — timestamp
- created_by — varchar(255)
- updated_by — varchar(255)
- deleted_by — varchar(255)
- created_ip — varchar(255)
- updated_ip — varchar(255)
- deleted_ip — varchar(255)
- order_no — int(11) — 관리자 페이지 커스텀 정렬 넘버링
reserve
- id — bigint(20) — Primary key — NOT NULL
- auct_id — int(11) — NOT NULL — 구매요청 ID
- offer_id — int(11) — NOT NULL — 구매제안 ID
- reserve_at — timestamp — 예약 날짜
- created_at — timestamp
- updated_at — timestamp
- deleted_at — timestamp
- created_by — varchar(255)
- updated_by — varchar(255)
- delete_by — varchar(255)
- created_ip — varchar(255)
- updated_ip — varchar(255)
- deleted_ip — varchar(255)
sms_api_access_token
- id — bigint(20) — Primary key — NOT NULL
- token — mediumtext — NOT NULL
- expires_at — timestamp
- created_at — timestamp
- updated_at — timestamp
sms_api_refresh_token
- id — bigint(20) — Primary key — NOT NULL
- access_token_id — int(11) — NOT NULL
- token — mediumtext — NOT NULL
- expires_at — timestamp
- created_at — timestamp
- updated_at — timestamp
user
- id — bigint(20) — Primary key — NOT NULL
- name — varchar(255) — NOT NULL — 이름
- birth — varchar(255) — NOT NULL — 생년월일
- gender — char(1) — NOT NULL — 성별
- email — varchar(255) — 계정(이메일)
- email_verified_at — timestamp
- password — varchar(255) — 비밀번호
- is_admin — tinyint(1) — NOT NULL — 관리자권한
- grade — int(11) — 등급
- auth_type — varchar(255) — 가입 구분
- created_at — timestamp
- updated_at — timestamp
- deleted_at — timestamp
- created_by — varchar(255)
- updated_by — varchar(255)
- deleted_by — varchar(255)
- created_ip — varchar(255)
- updated_ip — varchar(255)
- deleted_ip — varchar(255)