ThePick_20210414_v1

Tables (18)

Copy Of Copy Of Copy Of Untitled2 (sytem_user_category)

  • Key (seq) — smallint — Primary key — NOT NULL
  • Field (user_category_name) — varchar(50) — NOT NULL — 회원 종류 명칭

Copy Of Copy Of Untitled (module_payment_method)

  • Key (seq) — smallint — Primary key — NOT NULL
  • Field (payment_method_name) — varchar(50) — NOT NULL — 결제 방법 명칭

Copy Of Copy Of Untitled2 (sytem_bank)

  • Key (seq) — smallint — Primary key — NOT NULL
  • Field (bank_name) — varchar(50) — NOT NULL — 은행명
  • Field (bank_code) — varchar(10) — NOT NULL — 은행코드

Copy Of Untitled (module_order_status)

  • Key (seq) — smallint — Primary key — NOT NULL
  • Field (order_status_name) — varchar(50) — NOT NULL — 주문 상태 명칭

Copy Of Untitled2 (module_restorant_qr)

  • Key (seq) — bigint — Primary key — NOT NULL
  • Key (module_restorant_seq) — bigint — Foreign key → Untitled.Key — NOT NULL — ref:module_restorant.seq
  • Field (qr_date_request) — timestamp — NOT NULL — QR 요청일
  • Field (qr_date_process) — timestamp — QR 처리일

Untitled (module_restorant)

  • Key (seq) — bigint — Primary key — NOT NULL
  • seq (system_user_seq) — bigint — Foreign key → system_user.seq — NOT NULL — ref::system_user.seq
  • seq (restorant_license_image) — bigint — Foreign key → module_file_data.seq — NOT NULL — ref::module_file.seq
  • Field (restorant_id) — char(32) — NOT NULL — QR에 삽입할 값, UUID 로 생성
  • Field (restorant_name) — varchar(200) — NOT NULL — 식당 명칭
  • Field (restorant_images) — jsonb — NOT NULL — module_file.seq 를 Array 로 저장
  • Field (restorant_date) — timestamp — NOT NULL — 식당 등록 및 수정일
  • Field (restorant_owner) — varchar(50) — NOT NULL — 점주 성명
  • Field (restorant_telephone) — varchar(50) — NOT NULL — 식당 연락처
  • Field (restorant_address1) — varchar(200) — NOT NULL — 식당 주소
  • Field (restorant_address2) — varchar(200) — NOT NULL — 식당 상세 주소
  • Field (restorant_zipcode) — char(5) — NOT NULL — 식당 우편번호
  • Field (restorant_license_number) — varchar(50) — NOT NULL — 식당 사업자 번호

Untitled (module_table)

  • Key (seq) — bigint — Primary key — NOT NULL
  • Key (module_restorant_seq) — bigint — Foreign key → Untitled.Key — NOT NULL — ref::module_restorant.seq
  • Field (table_id) — char(32) — NOT NULL — QR에 삽입할 값, UUID 로 생성
  • Field (table_name) — varchar(200) — NOT NULL — 테이블 이름
  • Field (table_date) — timestramp — NOT NULL — 테이블 등록 일자

Untitled (module_dish_category)

  • Key (seq) — smallint — Primary key — NOT NULL
  • Field (dish_category_name) — varchar(50) — NOT NULL — 음식 카테고리 명칭

Untitled (module_order)

  • Key (seq) — bigint — Primary key — NOT NULL
  • seq (system_user_seq) — bigint — Foreign key → system_user.seq — NOT NULL — ref::system_user.seq
  • Key (module_table_seq) — bigint — Foreign key → Untitled.Key — NOT NULL — ref::module_table.seq
  • Key (order_status) — smallint — Foreign key → Copy Of Untitled.Key — NOT NULL — ref::module_order_status.seq
  • Key (module_payment_seq) — bigint — Foreign key → Untitled.Key — NOT NULL — ref::module_payment.seq
  • Field (order_dishes) — jsonb — NOT NULL — 주문 시점의 module_dish 의 row 를 JSON 화 하여 Array 로 저장
  • Field (order_date_request) — timestamp — NOT NULL — 주문 시간
  • Field (order_date_cancel) — timestamp — 취소 시간
  • Field (order_date_complet) — timestamp — 완료 시간

Untitled (module_survey)

  • Key (seq) — bigint — Primary key — NOT NULL
  • seq (system_user_seq) — bigint — Foreign key → system_user.seq — NOT NULL — ref::system_user.seq
  • Key (module_order_seq) — bigint — Foreign key → Untitled.Key — NOT NULL — ref::module_order.seq
  • Field (survey_point) — smallint — NOT NULL — 1점이 최저 인 10 점 만점 평가 값
  • Field (survey_comment) — text — NOT NULL — 평가 내용
  • Field (survey_date) — timestamp — NOT NULL — 평가 등록 및 수정일

Untitled (module_payment)

  • Key (seq) — bigint — Primary key — NOT NULL
  • Key (payment_method) — smallint — Foreign key → Copy Of Copy Of Untitled.Key — NOT NULL — ref::module_payment_method.seq
  • Field (payment_date) — timestamp — NOT NULL — 결제 시간
  • Field (payment_amount) — integer — NOT NULL — 결제 금액
  • Field (payment_token) — varchar(200) — NOT NULL — 결제 토큰

Untitled (module_dish)

  • Key (seq) — bigint — Primary key — NOT NULL
  • Key (module_restorant_seq) — bigint — Foreign key → Untitled.Key — NOT NULL — ref::module_restorant.seq
  • Key (dish_category) — smallint — Foreign key → Untitled.Key — NOT NULL — ref::module_dish_category.seq
  • Field (dish_name) — varchar(200) — NOT NULL — 음식 명칭
  • Field (dish_amount) — integer — NOT NULL — 음식 가격
  • Field (dish_images) — jsonb — NOT NULL — module_file.seq 를 Array 로 저장
  • Field (dish_description) — text — NOT NULL — 음식 설명
  • Field (dish_count_per_day) — smallint — NOT NULL — 1일 제공 가능한 수량
  • Field (dish_hide) — smallint — NOT NULL — 0:표시함, 1;표시하지 않음
  • Field (dish_date) — timestamp — NOT NULL — 음식 등록 및 수정일

Untitled (module_wallet)

  • Key (seq) — bigint — Primary key — NOT NULL
  • seq (system_user_seq) — bigint — Foreign key → system_user.seq — NOT NULL — ref::system_user.seq
  • Field (wallet_name) — varchar(50) — NOT NULL — 지갑 명칭
  • Field (wallet_token) — varchar(200) — NOT NULL — 지갑 결제용 토큰

Untitled (module_restorant_adjustment)

  • Key (seq) — bigint — Primary key — NOT NULL
  • Key (module_restorant_seq) — bigint — Foreign key → Untitled.Key — NOT NULL — ref::module_restorant.seq
  • Key (system_bank_seq) — smallint — Foreign key → Copy Of Copy Of Untitled2.Key — NOT NULL — ref::system_bank.seq
  • Field (restorant_adjustment_bank_account) — varchar(50) — NOT NULL — 정산 계좌 번호
  • Field (restorant_adjustment_bank_owner) — varchar(50) — NOT NULL — 정산 계좌주
  • Field (restorant_adjustment_amount) — integer — NOT NULL — 정산 금액
  • Field (restorant_adjustment_date) — timestamp — NOT NULL — 정산일

Untitled (system_user_extra)

  • seq (system_user_seq) — bigint — Foreign key → system_user.seq — NOT NULL — ref::system_user.seq
  • Key (system_bank_seq) — smallint — Foreign key → Copy Of Copy Of Untitled2.Key — NOT NULL — ref::system_bank.seq
  • Field (user_extra_bank_account) — varchar(50) — 정산 계좌 번호
  • Field (user_extra_bank_owner) — varchar(50) — 정산 계좌주

module_file_data (module_file)

  • seq — bigint — Primary key — NOT NULL
  • seq (system_user_seq) — bigint — Foreign key → system_user.seq — NOT NULL — ref::system_user.seq
  • file_uuid — char(32) — NOT NULL — 관리용, UUID 로 생성
  • file_filename — varchar(200) — NOT NULL — 오리지널 파일명
  • file_ext (file_mine) — varchar(100) — 파일타입
  • file_contains — jsonb — 연결되는 {"테이블명":"seq"} 형태 값, 연결이 없으면 NULL
  • file_realpath — text — NOT NULL — 서버에서 접근할 파일 경로
  • file_filelink — text — NOT NULL — URL 로 접근할 경로
  • file_created (file_date_create) — timestamp — NOT NULL — 파일 생성 시간

system_history_sms

  • seq — bigint — Primary key — NOT NULL
  • Field (history_sms_target) — varchar(50) — NOT NULL — 발송대상
  • Field (history_sms_text) — text — NOT NULL — 발송내용
  • Field (history_sms_date_send) — timestamp — NOT NULL — 발송시간
  • Field (history_sms_result) — varchar(200) — NOT NULL — 발송결과 (비정상인경우)

system_user

  • seq — bigint — Primary key — NOT NULL
  • Key (user_category) — smallint — Foreign key → Copy Of Copy Of Copy Of Untitled2.Key — NOT NULL — ref::sytem_user_category.seq
  • user_id — char(32) — NOT NULL — 회원ID, 관리용, UUID 로 생성
  • user_name — varchar(200) — NOT NULL — 회원이름
  • user_telephone — varchar(50) — NOT NULL — 회원전화번호
  • Field (user_date_birth) — date — NOT NULL — 회원생년월일
  • user_date_join — timestamp — NOT NULL — 회원가입일
  • user_date_signin — timestamp — 회원마지막로그인시간