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