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