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