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