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)