xfashion
Tables (25)
Cart (cart)
- id — char(32) — Primary key — NOT NULL
- user_id — char(32) — Foreign key → user.id — NOT NULL
- merchandise_id — char(32) — Foreign key → Merchandise.id — NOT NULL
- created_time — datetime — NOT NULL
Cart_Selection (cart_selection)
- id — char(32) — Primary key — NOT NULL
- cart_id — char(32) — Foreign key → Cart.id — NOT NULL
- merchandise_selection_id — char(32) — Foreign key → Merchandise_Selection.id — NOT NULL
- selection_type — smallint — Foreign key → Merchandise_Selection.selection_type — NOT NULL
Merchandise (merchandise)
- id — char(32) — Primary key — NOT NULL
- is_visible — boolean — NOT NULL
- stock_count — int — NOT NULL
- price — int — NOT NULL
- views — int — NOT NULL
- thumbnail_image_url — text
- title — varchar(256) — NOT NULL
- created_time — datetime — NOT NULL
- modified_time — datetime — NOT NULL
Merchandise_Description_Image (merchandise_description_image)
- id — char(32 — Primary key — NOT NULL
- merchandise_id — char(32) — Foreign key → Merchandise.id — NOT NULL
- sort_order — int — NOT NULL
- is_visible — boolean — NOT NULL
- storage_url — text — NOT NULL
- created_time — datetime — NOT NULL
- modified_time — datetime — NOT NULL
Merchandise_Image (merchandise_image)
- id — char(32) — Primary key — NOT NULL
- merchandise_id — char(32) — Foreign key → Merchandise.id — NOT NULL
- sort_order — int — NOT NULL
- is_visible — boolean — NOT NULL
- is_default — boolean — NOT NULL
- color — varchar(128) — NOT NULL
- storage_url — text — NOT NULL
- created_time — datetime — NOT NULL
- modified_time — datetime — NOT NULL
Merchandise_Selection (merchandise_selection)
- id — char(32) — Primary key — NOT NULL
- selection_type — smallint — Primary key — NOT NULL
- merchandise_id — char(32) — Foreign key → Merchandise.id — NOT NULL
- is_visible — boolean — NOT NULL
- content — text — NOT NULL
- created_time — datetime — NOT NULL
- modified_time — datetime — NOT NULL
Order Group (order_group)
- id — char(32) — Primary key — NOT NULL
- user_id — char(32) — Foreign key → user.id — NOT NULL
- status — int — NOT NULL
- total_price — int — NOT NULL
- orderer_name — varchar(64) — NOT NULL
- orderer_email — varchar(64)
- orderer_phone_no — varchar(64) — NOT NULL
- receiver_name — varchar(64) — NOT NULL
- receiver_phone_no — varchar(64) — NOT NULL
- delivery_address — text — NOT NULL
- delivery_requirement — text — NOT NULL
- summary_title — varchar(128) — NOT NULL
- created_time — datetime — NOT NULL
Order_Selection (order_selection)
- id — char(32) — Primary key — NOT NULL
- single_order_id — char(32) — Foreign key → SingleOrder.id — NOT NULL
- merchandise_selection_id — char(32) — Foreign key → Merchandise_Selection.id — NOT NULL
- selection_type — smallint — Foreign key → Merchandise_Selection.selection_type — NOT NULL
Payment_Log (payment_log)
- id — char(32) — Primary key — NOT NULL
- order_group_id — char(32) — Foreign key → Order Group.id — NOT NULL
- 결제 상황 (status) — smallint — NOT NULL
- 결제 금액 (price) — int — NOT NULL
- 결제용 타임스탬프 (timestamp) — long — NOT NULL
- 결제 수단 (pay_method) — varchar(32) — NOT NULL
- 결제 billing id (tid) — char(40)
- 주문번호 (oid) — varchar(40) — NOT NULL
- 결제 승인 날짜 (paid_time) — datetime
- created_time — datetime — NOT NULL
- modified_time — datetime — NOT NULL
Review (review)
- id — char(32) — Primary key — NOT NULL
- user_id — char(32) — Foreign key → user.id — NOT NULL
- merchandise_id — char(32) — Foreign key → Merchandise.id — NOT NULL
- is_visible — boolean — NOT NULL
- stars — smallint — NOT NULL
- like_count — int — NOT NULL
- created_time — datetime — NOT NULL
- modified_time — datetime — NOT NULL
- content — text — NOT NULL
SingleOrder (single_order)
- id — char(32) — Primary key — NOT NULL
- order_group_id — char(32) — Foreign key → Order Group.id — NOT NULL
- merchandise_id — char(32) — Foreign key → Merchandise.id — NOT NULL
- count — int — NOT NULL
- created_time — datetime — NOT NULL
User_Review_Like (user_review_like)
- id — Primary key — NOT NULL
- review_id — char(32) — Foreign key → Review.id — NOT NULL
- user_id — char(32) — NOT NULL
- created_time — datetime — NOT NULL
User_Token (user_token)
- id — char(32) — Primary key — NOT NULL
- user_id — char(32) — Foreign key → user.id — NOT NULL
- refresh_token — text — NOT NULL
- login_ip — char(15) — NOT NULL
- expired_time — datetime — NOT NULL
- created_time — datetime — NOT NULL
Wishlist (wishlist)
- id — char(32) — Primary key — NOT NULL
- user_id — char(32) — Foreign key → user.id — NOT NULL
- merchandise_id — char(32) — Foreign key → Merchandise.id — NOT NULL
- created_time — datetime — NOT NULL
avatar
- id — char(32) — Primary key — NOT NULL
- user_id — char(32) — Foreign key → user.id — NOT NULL
- status — smallint — NOT NULL
- height — int — NOT NULL
- weight — int — NOT NULL
- created_time — datetime — NOT NULL
- finished_time — datetime
inferenced_ai_image
- id — char(32) — Primary key — NOT NULL
- avatar_id — char(32) — Foreign key → avatar.id — NOT NULL
- merchandise_ai_image_id — char(32) — Foreign key → merchandise_ai_image.id — NOT NULL
- status — smallint — NOT NULL
- created_time — datetime — NOT NULL
- finished_time — datetime
label
- id — varchar(32) — Primary key — NOT NULL
- is_visible — boolean — NOT NULL
- name — varchar(32) — NOT NULL
- type — varchar(32) — NOT NULL
merchandise_ai_image
- id — char(32) — Primary key — NOT NULL
- merchandise_id — char(32) — Foreign key → Merchandise.id — NOT NULL
- status — smallint — NOT NULL
- color — varchar(64) — NOT NULL
- created_time — datetime — NOT NULL
- finished_time — datetime
merchandise_label
- id — char(32) — Primary key — NOT NULL
- merchandise_id — char(32) — Foreign key → Merchandise.id — NOT NULL
- label_id — varchar(32) — Foreign key → label.id — NOT NULL
message_code
- code — char(6) — Primary key — NOT NULL
- valid_time — datetime — NOT NULL
- phone_no — varchar(11) — NOT NULL
temp_user
- register_token — char(32) — Primary key — NOT NULL
- login_type — varchar(10) — NOT NULL
- unique_info — varchar(1024) — NOT NULL
- email — varchar(128)
user
- id — char(32) — Primary key — NOT NULL
- is_withdrawal — boolean — NOT NULL
- phone_no — varchar(11)
- name — varchar(64) — NOT NULL
- nickname — varchar(128) — NOT NULL
- email — varchar(128)
- created_time — datetime — NOT NULL
- modified_time — datetime — NOT NULL
user_delivery_info
- id — char(32) — Primary key — NOT NULL
- user_id — char(32) — Foreign key → user.id — NOT NULL
- is_main — boolean — NOT NULL
- address — varchar(1024) — NOT NULL
- created_time — datetime — NOT NULL
- detail_address — text
user_login_info
- id — char(32) — Primary key — NOT NULL
- user_id — char(32) — Foreign key → user.id — NOT NULL
- login_type — varchar(10) — NOT NULL
- unique_info — varchar(1024) — NOT NULL
- last_access_time — datetime — NOT NULL
- created_time — datetime — NOT NULL
- modified_time — datetime — NOT NULL
user_payment_card
- id — char(32) — Primary key — NOT NULL
- user_id — char(32) — Foreign key → user.id — NOT NULL
- is_main — boolean — NOT NULL
- 만료 연도 (expire_year) — char(2) — NOT NULL
- 만료 월 (expire_month) — char(2) — NOT NULL
- 생년월일 (birth) — char(6) — NOT NULL
- 생성날짜 (created_time) — datetime — NOT NULL
- 수정날짜 (modified_time) — datetime — NOT NULL
- 결제 카드 번호 (masked_card_no) — varchar(30) — NOT NULL
- 결제 키 (bill_key) — varchar(100) — NOT NULL
- 카드 비밀번호 앞자리 (sha) (password_prefix) — varchar(512) — NOT NULL
- rsa encrypted 카드번호 (encrypt_card_no) — varchar(512) — NOT NULL
- 중복감지용 hmacsha256 된 해시된 카드번호 (hmac_card_no) — varchar(512) — NOT NULL
- simple_password — varchar(512) — NOT NULL
- is_deleted — boolean — NOT NULL