포인트
테이블 (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