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