쇼핑몰
테이블 (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