Coupon
Tables (9)
Category (카테고리)
- seq — int — Primary key — NOT NULL
- pseq — int
- name (이름) — varchar
Coupon (쿠폰)
- seq — int — Primary key — NOT NULL
- cpseq (쿠폰정책 seq) — int — Foreign key → CouponPolicy.seq — NOT NULL
- user_seq (User seq) — int — Foreign key → User.seq — NOT NULL
- code (코드) — varchar(100)
- name (쿠폰명) — varchar(300)
- expiry_start_datetime (유효기간 시작일) — datetime
- expiry_end_datetime (유효기간 종료일) — datetime
- application (ALL/웹/앱) — int
- brand (브랜드) — int
- category (카테고리) — int
- value (값) — int
- isUsed (사용여부) — boolean
- used_datetime (사용일) — datetime
- register (등록자) — varchar(100)
- reg_datetime (등록일) — datetime
- deleter (삭제자) — varchar(100)
- delete_datetime (삭제일) — datetime
CouponPolicy (쿠폰 정책)
- seq — int — Primary key — NOT NULL
- type (종류) — int — Foreign key → Node.seq — NOT NULL
- name (정책명) — varchar(100)
- coupon_name (쿠폰명) — varchar(100)
- content (내용) — text
- application (ALL/웹/앱) — int
- brand (브랜드) — int — Foreign key → Option.seq — NOT NULL
- category (카테고리) — int — Foreign key → Category.seq — NOT NULL
- value (값) — int
- expiry_start_datetime (유효기간 시작일) — datetime
- expiry_end_datetime (유효기간 종료일) — datetime
- register (등록자) — varchar(100)
- reg_datetime (등록일) — datetime
- deleter (삭제자) — varchar(100)
- delete_datetime (삭제일) — datetime
CouponPolicyFile (쿠폰 정책 첨부파일)
- seq — int — Primary key — NOT NULL
- cpseq (정책seq) — int — Foreign key → CouponPolicy.seq — NOT NULL
- type (종류) — int — Foreign key → Node.seq — NOT NULL
- file_name (파일명) — varchar(300)
- register (등록자) — varchar(100)
- reg_datetime (등록일) — datetime
- deleter (삭제자) — varchar(100)
- delete_datetime (삭제일) — datetime
Model (모델)
- seq — int — Primary key — NOT NULL
- name — varchar
ModelOption (모델 옵션)
- seq — int — Primary key — NOT NULL
- model_seq (모델 seq) — int — Foreign key → Model.seq — NOT NULL
- model_name (모델명) — varchar — Foreign key → Model.seq — NOT NULL
- option_seq (옵션 seq) — int — Foreign key → Option.seq — NOT NULL
Node
- seq — int — Primary key — NOT NULL
- pseq — int
- name — varchar
- note — varchar
Option (옵션)
- seq — Primary key — NOT NULL
- pseq — int
- name — varchar
- value
User (회원)
- seq — seq — Primary key — NOT NULL
- userId (Field) — varchar(200)
- userPw (Field2) — text