Point

테이블 (3)

주문 내역 (Untitled2)

  • order_no — int — 기본 키 — NOT NULL
  • user_no (user_no2) — int — 외래 키 → 회원 정보.user_no — NOT NULL — Auto_Increment
  • point_no — int — 외래 키 → 포인트.point_no — NOT NULL
  • partner — char(2) — NOT NULL
  • order_status — char(1) — NOT NULL
  • goods_no — int — NOT NULL
  • unit_amt — int — NOT NULL
  • send_name — varchar(45)
  • send_msg — varchar(500)
  • templete_no — int
  • pg_type — char(1) — NOT NULL
  • order_amt — datetime — NOT NULL
  • order_cnt — int — NOT NULL
  • succ_cnt — int
  • fail_cnt — int
  • pnt_used — int
  • promotion_code — varchar(250)
  • promotion_amt — int

포인트 (Untitled3)

  • point_no — int — 기본 키 — NOT NULL
  • user_no (user_no2) — int — 외래 키 → 회원 정보.user_no — NOT NULL — Auto_Increment
  • point_amt — int — NOT NULL
  • point_use — int
  • point_type — char(1) — NOT NULL
  • point_reason — char(1) — NOT NULL
  • order_id — int
  • reg_dt — datetime — NOT NULL
  • expire_dt — datetime

회원 정보 (Untitled)

  • user_no — int — 기본 키 — NOT NULL — Auto_Increment
  • user_id — varchar(128) — NOT NULL
  • user_pwd — varchar(64)
  • user_name — varchar(64)
  • sub_name — varchar(64)
  • user_status — char(4) — NOT NULL
  • fail_cnt — tinyint(3)
  • login_dt — datetime — NOT NULL
  • pwd_dt — datetime — NOT NULL
  • reg_dt — datetime — NOT NULL
  • mod_dt — datetime — NOT NULL
  • temp_pwd_yn — char(1)
  • gender — char(1)
  • birthday — char(8)
  • social_type — char(1)
  • social_id — varchar(45)
  • point_amt — int