TeemoShopping

Tables (23)

Accounts

  • accounts_id (아이디) — bigint — Primary key — NOT NULL
  • username (유저이름) — varchar
  • password (암호화된 비밀번호) — varchar
  • created_at (생성일자) — datetime
  • updated_at (수정일자) — datetime

AccountsCoupons

  • accounts_has_coupons_id (아이디) — bigint — Primary key — NOT NULL
  • accounts_id (계정) — bigint — Foreign key → Accounts.accounts_id — NOT NULL
  • coupon_id (쿠폰) — bigint — Foreign key → Coupons.coupon_id — NOT NULL
  • created_at (생성일자) — datetime
  • updated_at (수정일자) — datetime

AccountsFollowGames

  • accounts_follow_games_id (아이디) — bigint — Primary key
  • accounts_id (계정) — bigint — Foreign key → Accounts.accounts_id — NOT NULL
  • games_id (게임) — bigint — Foreign key → Games.games_id — NOT NULL
  • created_at (생성일자) — datetime
  • updated_at (수정일자) — datetime

AccountsOwnGames

  • accounts_own_games_id (아이디) — bigint — Primary key — NOT NULL
  • accounts_id (계정) — bigint — Foreign key → Accounts.accounts_id — NOT NULL
  • games_id (게임) — bigint — Foreign key → Games.games_id — NOT NULL
  • created_at (생성일자) — datetime
  • updated_at (수정일자) — datetime

CouponCategories

  • coupons_has_categories_id (아이디) — bigint — Primary key — NOT NULL
  • coupon_id (쿠폰) — bigint — Foreign key → Coupons.coupon_id — NOT NULL
  • categories_id (카테고리) — bigint — Foreign key → GameCategories.categories_id — NOT NULL
  • created_at (생성일자) — datetime
  • updated_at (수정일자) — datetime

CouponGames

  • coupons_has_games_id (아이디) — bigint — Primary key — NOT NULL
  • coupon_id (쿠폰) — bigint — Foreign key → Coupons.coupon_id — NOT NULL
  • games_id (게임) — bigint — Foreign key → Games.games_id — NOT NULL
  • created_at (생성일자) — datetime
  • updated_at (수정일자) — datetime

CouponIssuers

  • couponIssuers_id (아이디) — Primary key — NOT NULL
  • coupon_id (쿠폰아이디) — bigint — Foreign key → Coupons.coupon_id — NOT NULL
  • amount (쿠폰수량) — int
  • name (쿠폰이름) — varchar — NOT NULL
  • description (쿠폰설명) — varchar
  • expired_at (만료기간) — datetime
  • isNewAccount (새로운유저) — bit
  • isFirstCome (선착순) — bit
  • created_at (생성일자) — datetime
  • updated_at (수정일자) — datetime

CouponIssuersAccounts

  • coupon_issuers_accounts_id (아이디) — bigint — Primary key — NOT NULL
  • couponIssuers_id (쿠폰아이디) — bigint — Foreign key → CouponIssuers.couponIssuers_id — NOT NULL
  • accounts_id (계정아이디) — bigint — Foreign key → Accounts.accounts_id — NOT NULL

CouponPayments

  • payments_id (부모아이디) — bigint — Foreign key → Payments.payments_id — NOT NULL
  • games_id (게임) — bigint — Foreign key → Games.games_id — NOT NULL
  • coupon_id (쿠폰) — bigint — Foreign key → Coupons.coupon_id — NOT NULL

Coupons

  • coupon_id (아이디) — bigint — Primary key — NOT NULL
  • name (쿠폰이름) — varchar — NOT NULL
  • description (쿠폰설명) — varchar
  • max_discount_price (최대 할인 금액) — int
  • min_discount_price (최소 할인 금액) — int
  • min_fulfill_price (최소 충족 금액) — int
  • method (할인방법 (Percent/Static)) — string
  • amount (할인 양) — double
  • expired_at (만료기간) — datetime
  • created_at (생성일자) — datetime
  • updated_at (수정일자) — datetime

DiscountPayments (CopyOfUntitled15)

  • Key — bigint — Primary key — NOT NULL
  • payments_id (부모아이디) — bigint — Foreign key → Payments.payments_id — NOT NULL

GameCategories

  • categories_id (아이디) — bigint — Primary key — NOT NULL
  • name (이름) — varchar
  • created_at (생성일자) — datetime
  • updated_at (수정일자) — datetime

GameCategoriesGames

  • game_categories_has_games (아이디) — bigint — Primary key — NOT NULL
  • games_id (게임) — bigint — Foreign key → Games.games_id — NOT NULL
  • categories_id (카테고리) — bigint — Foreign key → GameCategories.categories_id — NOT NULL
  • created_at (생성일자) — datetime
  • updated_at (수정일자) — datetime

Games

  • games_id (아이디) — bigint — Primary key — NOT NULL
  • name (게임이름) — varchar(30)
  • description (설명) — varchar(255)
  • rating (평점) — decimal
  • rating_count (평점개수) — int
  • price (가격) — int
  • discount (할인율) — decimal
  • created_at (생성일자) — datetime
  • updated_at (수정일자) — datetime

GamesResources

  • games_has_resources_id (아이디) — bigint — Primary key — NOT NULL
  • games_id (게임) — bigint — Foreign key → Games.games_id — NOT NULL
  • resources_id (리소스) — bigint — Foreign key → Resources.resources_id — NOT NULL
  • created_at (생성일자) — datetime
  • updated_at (수정일자) — datetime

KakaopayPayments

  • payments_id (부모아이디) — bigint — Foreign key → Payments.payments_id — NOT NULL
  • tid (카카오페이API_고유아이디) — varchar
  • cid (주문아이디) — varchar
  • redirect (Client용 리다이렉트) — varchar
  • redirect_secret (리다이렉트 검증코드) — varchar
  • pg_token — varchar
  • kakaoapi_state (카카오페이 API 상태) — varchar
  • partner_user_id — varchar
  • partner_order_id — varchar
  • item_name (아이템이름) — varchar

Orders

  • orders_Id (Key) — bigint — Primary key — NOT NULL
  • accounts_id (아이디) — bigint — Foreign key → Accounts.accounts_id — NOT NULL
  • tatal_price (총금액) — int
  • status (상태) — varchar
  • created_at (생성일자) — datetime
  • updated_at (수정일자) — datetime

OrdersGames

  • orders_has_games_id (아이디) — bigint — Primary key — NOT NULL
  • orders_Id (주문) — bigint — Foreign key → Orders.orders_Id — NOT NULL
  • games_id (게임) — bigint — Foreign key → Games.games_id — NOT NULL
  • status (상태) — varchar
  • created_at (생성일자) — datetime
  • updated_at (수정일자) — datetime

OrdersPayments

  • orders_has_payments_id (아이디) — bigint — Primary key — NOT NULL
  • payments_id (결제) — bingint — Foreign key → Payments.payments_id — NOT NULL
  • created_at (생성일자) — datetime
  • updated_at (수정일자) — datetime
  • orders_Id (Key) — bigint — Foreign key → Orders.orders_Id — NOT NULL

Payments

  • payments_id (아이디) — bigint — Primary key — NOT NULL
  • method (결제방식) — varchar
  • price (가격) — int
  • status (상태) — varchar
  • created_at (생성일자) — datetime
  • updated_at (수정일자) — datetime
  • dtype — varchar

PointPayments

  • payments_id (부모아이디) — bigint — Foreign key → Payments.payments_id — NOT NULL

Resources

  • resources_id (아아디) — bigint — Primary key — NOT NULL
  • origin (오리진)
  • path (경로) — varchar
  • type (MIME) — varchar
  • created_at (생성일자) — datetime
  • updated_at (수정일자) — datetime

Reviews

  • reviews_id (Key) — bigint — Primary key — NOT NULL
  • content (내용) — varchar
  • rating (평점) — int
  • accounts_id (계정) — bigint — Foreign key → Accounts.accounts_id — NOT NULL
  • games_id (게임) — bigint — Foreign key → Games.games_id — NOT NULL
  • created_at (생성일자) — datetime
  • updated_at (수정일자) — datetime