쇼핑몰

테이블 (7)

Auth

  • auth_id — BIGINT — 기본 키 — NOT NULL
  • auth_level — VARCHAR(50) — NOT NULL
  • auth_type — VARCHAR(30) CHECK (auth_type IN ('USER', 'ADMIN')) — NOT NULL

Delivery_Address

  • id — BIGINT — 기본 키 — NOT NULL
  • user_id — BIGINT — 외래 키 → User.user_id — NOT NULL
  • address — VARCHAR(400) — NOT NULL
  • address_details — VARCHAR(150)
  • address_post_no — VARCHAR(10) — NOT NULL
  • address_level — INT — NOT NULL
  • tracking_deverily_no — INT
  • registed_date — DATETIME — NOT NULL
  • updated_date — DATETIME — NOT NULL

Item

  • id — BIGINT — 기본 키 — NOT NULL
  • catrgory_id — BIGINT — 외래 키 → Item_Category.id — NOT NULL
  • sales_info_id — BIGINT — 외래 키 → Item_special_sales_info.id — NOT NULL
  • item_name — VARCHAR(200) — NOT NULL
  • item_description — TEXT
  • registed_date — DATETIME — NOT NULL
  • updated_date — DATETIME — NOT NULL

Item_Category

  • id — BIGINT — 기본 키 — NOT NULL
  • category_id — BIGINT — NOT NULL
  • catrgory_name — VARCHAR(400) — NOT NULL
  • id_using — CHAR(1) — NOT NULL
  • registed_date — DATETIME — NOT NULL
  • updated_date — DATETIME — NOT NULL

Item_special_sales_info

  • id — BIGINT — 기본 키 — NOT NULL
  • base_discount — DECIMAL(10, 2) — NOT NULL
  • extra_discount — DECIMAL(10, 2) — NOT NULL
  • sales_title — VARCHAR(100) — NOT NULL
  • registed_date — DATETIME — NOT NULL
  • updated_date — DATETIME — NOT NULL

Optional_User_Info

  • user_id — BIGINT — 외래 키 → User.user_id — NOT NULL
  • mobile — VARCHAR(50)
  • social_login_info — TEXT
  • is_black — CHAR(1) — NOT NULL

User

  • user_id — BIGINT — 기본 키 — NOT NULL
  • auth_id (auth_id2) — BIGINT — 외래 키 → Auth.auth_id — NOT NULL
  • login_id — VARCHAR(150) — NOT NULL
  • login_password — TEXT — NOT NULL
  • user_name — VARCHAR(50) — NOT NULL
  • optional_info_id — BIGINT — NOT NULL
  • is_lock — CHAR(1) — NOT NULL
  • registed_date — DATETIME — NOT NULL
  • updated_date — DATETIME — NOT NULL