sahara
Tables (4)
t_mnb_card (일별카드사용액)
- 카드종류 (card_div) — char(4) — Primary key — NOT NULL
- 결제일 (payment_date) — varchar(8) — Primary key — NOT NULL
- 회원ID (user_id) — varchar(50) — Foreign key → t_mnb_member.회원ID — NOT NULL
- 결제금액 (payment_amt) — numeric
t_mnb_cash (일별현금사용액)
- 결제일 (payment_date) — varchar(8) — Primary key — NOT NULL
- 회원ID (user_id) — varchar(50) — Foreign key → t_mnb_member.회원ID — NOT NULL
- 결제금액 (payment_amt) — numeric
t_mnb_member (회원)
- 회원ID (user_id) — varchar(50) — Primary key — NOT NULL
- 회원이름(성) (user_last_name) — varchar(30)
- 회원이름(이름) (user_first_name) — varchar(50)
- Email (user_email) — varchar(50)
- 등록일 (create_dtime) — timestamp
- 등록유저 (create_user) — varchar(50)
- 수정일 (update_time) — timestamp
- 수정유저 (update_user) — varchar(50)
- 비밀번호 (user_password) — varchar(30) — NOT NULL
t_mnb_subscription (구독료)
- 구독종류 (subscrt_div) — char(4) — Primary key — NOT NULL
- 회원ID (user_id) — varchar(50) — Foreign key → t_mnb_member.회원ID — NOT NULL
- 구독료 (subscrt_amt) — numeric