화담 결제 DB
테이블 (17)
Admin
- id — text — NOT NULL
- password — text — NOT NULL
- name — text — NOT NULL
Category
- id — serial4 — 기본 키 — NOT NULL
- name — text — NOT NULL
Check_Shop_Valid
- id — text — 기본 키 — NOT NULL
- registration — text
- business_report — text
- bank_book — text
- shop_front — text
- shop_inner — text
- shop_id — text
- reject_reason — text
CustomProduct (CopyOfProduct)
- id — 기본 키 — NOT NULL
- shop_id — text — 외래 키 → Product.shop_id — NOT NULL
- price — float8 — NOT NULL
- name — text — NOT NULL
- simple_explain — text — NOT NULL
- origin — text — NOT NULL
- sale — bool — NOT NULL
- category_id — int4 — NOT NULL
- status
Custom_Flower
- id — text — 기본 키 — NOT NULL
- pick_up_date — text — NOT NULL
- pick_up_time — text — NOT NULL
- price — float8 — NOT NULL
- quantity — int4 — NOT NULL
- type — text — NOT NULL
- color — text — NOT NULL
- purpose — text — NOT NULL
- keyword — text — NOT NULL
- require — text — NOT NULL
- recipient — text — NOT NULL
Flower_Descript_Image
- id — text — 기본 키 — NOT NULL
- url — text — NOT NULL
- represent_id — text
Flower_Image
- id — text — 기본 키 — NOT NULL
- url — text — NOT NULL
- represent_id — text
Order (Untitled2)
- id — 기본 키 — NOT NULL
- user_id — text — 외래 키 → User.id — NOT NULL
- payment_id — 외래 키 → Payment.페이먼트키 — NOT NULL
- total_price
- create_at
OrderProduct (Untitled)
- id (Key) — 기본 키 — NOT NULL
- order_id — 외래 키 → Order.id — NOT NULL
- user_id — text — 외래 키 → User.id — NOT NULL
- product_id — text — 외래 키 → Product.id — NOT NULL
- custom_product_id — 외래 키 → CustomProduct.id — NOT NULL
- pick_up_date
- amount
Owner
- id — text — 기본 키 — NOT NULL
- email — text — NOT NULL
- password — text — NOT NULL
- name — text — NOT NULL
- birth — int4 — NOT NULL
- phone_number — text — NOT NULL
- profile_url — text
- created_at — timestamp(3) — NOT NULL
- hashedRt — text
Payment
- 페이먼트키 (paymentKey) — String — 기본 키 — NOT NULL
- 버젼 (version) — String
- 결제타입 (type) — String
- 주문ID (orderId) — String
- 상점아이디 (mId) — String
- 통화 (currency) — String
- 결제수단 (method) — String
- 총결제금액 (totalAmount) — Number
- 잔고 (balanceAmount) — Number
- 결제상태 (status) — Date
- 결제날짜 (requestedAt) — Date
- 승인날짜 (approvedAt) — Date
- 거래키값 (lastTransactionKey) — String
- 공급가액 (suppliedAmount) — Number
- 부가세 (vat) — Number
- 면세금액 (taxFreeAmount) — Number
- 결제금액(세금제외) (taxExemptionAmount) — Number
- 취소금액 (cancelAmount) — Number
- 취소이유 (cancelReason) — Number
- Field17
- Field18
- Field19
- Field20
- Field21
- Field22
Product
- id — text — 기본 키 — NOT NULL
- shop_id — text — 외래 키 → Shop.id — NOT NULL
- price — float8 — NOT NULL
- name — text — NOT NULL
- simple_explain — text — NOT NULL
- origin — text — NOT NULL
- sale — bool — NOT NULL
- category_id — int4 — NOT NULL
Review
- id — serial4 — 기본 키 — NOT NULL
- rating — int4 — NOT NULL
- writer_id — text — NOT NULL
- store_id — text — NOT NULL
- text — text
- created_at — timestamp(3) — NOT NULL
Review_Image
- id — text — 기본 키 — NOT NULL
- review_id — int4 — NOT NULL
- image_url — text — NOT NULL
- created_at — timestamp(3) — NOT NULL
Review_Reply
- id — text — 기본 키 — NOT NULL
- review_id — int4 — NOT NULL
- store_id — text — NOT NULL
- text — text — NOT NULL
- created_at — timestamp(3) — NOT NULL
Shop
- id — text — 기본 키 — NOT NULL
- name — text — NOT NULL
- introduction — text
- open_time — text — NOT NULL
- close_time — text — NOT NULL
- shop_number — text — NOT NULL
- personal_number — text — NOT NULL
- latitude — float8
- longitude — float8
- address — text — NOT NULL
- detail_address — text — NOT NULL
- check_shop_valid_id — text
- owner_id — text
- sell — bool — NOT NULL
- atelier — bool — NOT NULL
- classroom — bool — NOT NULL
- etc — bool — NOT NULL
- mon — bool — NOT NULL
- tue — bool — NOT NULL
- wed — bool — NOT NULL
- thu — bool — NOT NULL
- fri — bool — NOT NULL
- sat — bool — NOT NULL
- sun — bool — NOT NULL
- permission — bool
User
- id — text — 기본 키 — NOT NULL
- email — text — NOT NULL
- password — text — NOT NULL
- name — text — NOT NULL
- nickname — text — NOT NULL
- birth — int4 — NOT NULL
- phone_number — text — NOT NULL
- profile_url — text
- apple_auth — bool — NOT NULL
- google_auth — bool — NOT NULL
- naver_auth — bool — NOT NULL
- kakao_auth — bool — NOT NULL
- created_at — timestamp(3) — NOT NULL
- hashedRt — text