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 — 회원마지막로그인시간