포인트

테이블 (8)

dining

  • di_seq — int — 기본 키 — NOT NULL

invitation

  • seq — int — 기본 키 — NOT NULL

request

  • rq_id — int — 기본 키 — NOT NULL

user

  • uid — int — 기본 키 — NOT NULL

user_account

  • account_seq — int — 기본 키 — NOT NULL
  • uid — int — 외래 키 → user.uid — NOT NULL
  • user_name — varchar — NOT NULL
  • regi_num — varchar — NOT NULL
  • bank_name — varchar — NOT NULL
  • account_name — varchar — NOT NULL
  • account_num — varchar — NOT NULL
  • mod_date — datetime — NOT NULL

user_point

  • point_seq — int — 기본 키 — NOT NULL
  • uid — int — 외래 키 → user.uid — NOT NULL
  • point_num_total — int — NOT NULL
  • point_num_use — int — NOT NULL
  • point_num_cur — int — NOT NULL
  • mod_date — datetime — NOT NULL

user_point_log

  • log_seq — int — 기본 키 — NOT NULL
  • point_seq — int — 외래 키 → user_point.point_seq — NOT NULL
  • uid — int — 외래 키 → user_point.uid — NOT NULL
  • di_seq — int — 외래 키 → dining.di_seq
  • seq — int — 외래 키 → invitation.seq
  • is_inout — char — NOT NULL
  • point_num_proc — int — NOT NULL
  • point_num_result — int — NOT NULL
  • note — text
  • reg_date — datetime — NOT NULL

user_point_transfer

  • transfer_seq — int — 기본 키 — NOT NULL
  • point_seq — int — 외래 키 → user_point.point_seq — NOT NULL
  • uid — int — 외래 키 → user_point.uid — NOT NULL
  • rq_id — int — 외래 키 → request.rq_id
  • price_origin — int — NOT NULL
  • tax_income — float — NOT NULL
  • tax_resident — float — NOT NULL
  • price_result — int — NOT NULL
  • is_transfer — tinyint — NOT NULL
  • transfer_date — datetime — NOT NULL
  • user_name — varchar — NOT NULL
  • regi_num — varchar — NOT NULL
  • bank_name — varchar — NOT NULL
  • account_name — varchar — NOT NULL
  • account_num — varchar — NOT NULL
  • reg_date — datetime — NOT NULL