final_pjt

Tables (5)

Tb_FA (FA 테이블)

  • FASeq (FA코드) — int — Primary key — NOT NULL
  • Email (이메일) — varchar
  • Id (아이디) — varhar
  • memo (문의내용) — text

Tb_Item (상품 테이블)

  • ItemSeq (제품코드) — int — Primary key — NOT NULL
  • ItemName (제품명) — varchar
  • ItemPrice (제품가격) — decimal
  • Category (카테고리) — varchar
  • memo (비고) — text
  • InsertDateTime (입력날짜) — datetime
  • UpdateDateTime (수정날짜) — datetime

Tb_Order (리워드사용이력 테이블)

  • OrderSeq (주문seq) — int — Primary key — NOT NULL
  • UserSeq (유저코드) — int — Foreign key → Tb_User.UserSeq — NOT NULL
  • ItemSeq (제품코드) — int — Foreign key → Tb_Item.ItemSeq — NOT NULL
  • IsReward (적립여부) — char
  • UseReward (사용리워드) — decimal
  • RestReward (남은리워드) — decimal
  • OrderDate (주문날짜) — varchar
  • OrderTime (주문시간) — varchar
  • InsertDateTime (입력날짜) — datetime
  • UpdateDateTime (수정날짜) — datetime

Tb_Reward (리워드이력 테이블)

  • RewardSerl (순번) — int — Primary key — NOT NULL
  • UserSeq (유저코드) — int — Foreign key → Tb_User.UserSeq — NOT NULL
  • isEarn (적립여부) — char
  • Reward (리워드점수) — decimal
  • rewardDate (날짜) — varchar
  • rewardTime (시간) — varchar
  • InsertDateTime (입력날짜) — datetime
  • UpdateDateTime (수정날짜) — datetime

Tb_User (사용자 테이블)

  • UserSeq (유저코드) — int — Primary key — NOT NULL
  • UserId (아이디) — varchar
  • Pw (패스워드) — varchar
  • Email (이메일) — varchar
  • regDate (회원가입날짜) — varchar
  • regTime (회원가입시간) — varchar
  • InsertDateTime (입력날짜) — datetime
  • UpdateDateTime (수정날짜) — datetime