springboot4-market

Tables (7)

Cart (장바구니)

    Order (주문)

      Product (상품)

        Stock (재고)

          Users (고객)

          • id (키) — int — Primary key — NOT NULL
          • email (유저이메일) — varchar(255)
          • user_email (유저이메일(가상컬럼)) — user_email VARCHAR(255) GENERATED ALWAYS AS ( CASE WHEN status = 'ACTIVE' THEN email ELSE NULL END ) STORED
          • password (비밀번호) — varchar(255)
          • username (유저 이름) — varchar(50)
          • provider (소셜기업들) — ENUM('LOCAL','GOOGLE','KAKAO','NAVER')
          • provider_user_id (소셜유저식별id) — VARCHAR(255)
          • status (회원 상태) — ENUM('ACTIVE','DELETED','SUSPENDED') NOT NULL DEFAULT 'ACTIVE'
          • created_at (회원 생성 날찌) — TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP
          • deleted_at (회원 탈퇴 날짜) — timestamp CHECK ( (status = 'DELETED' AND deleted_at IS NOT NULL) OR (status <> 'DELETED' AND deleted_at IS NULL) )

          Users (고객1)

          • id (키) — int — Primary key — NOT NULL
          • email (유저이메일) — varchar(255)
          • password (비밀번호) — varchar(255)
          • username (유저 이름) — varchar(50)
          • status (회원 상태) — ENUM('ACTIVE','DELETED','SUSPENDED') NOT NULL DEFAULT 'ACTIVE'
          • created_at (회원 생성 날찌) — TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP
          • deleted_at (회원 탈퇴 날짜) — timestamp CHECK ( (status = 'DELETED' AND deleted_at IS NOT NULL) OR (status <> 'DELETED' AND deleted_at IS NULL) )

          address (배송지)