Chain_Lighting_Company

테이블 (5)

결제 (Pay)

  • userid (2) — STRING — 외래 키 → 사용자.userid — NOT NULL
  • pay_name (Field4) — string — NOT NULL
  • pay_info (Field3) — json
  • pay_money (Field2) — integer — NOT NULL
  • created_time (Field) — timestamp — NOT NULL

사용자 (User)

  • userid — STRING — 기본 키 — NOT NULL
  • passwd (Field) — string — NOT NULL
  • passwd_update_time (Field2) — timestamp
  • name (Field3) — string — NOT NULL
  • opts (Field4) — json — 기타정보
  • created_time (Field5) — timestamp — NOT NULL
  • updated_time (Field6) — timestamp — NOT NULL
  • 선불결제 (Field8)
  • 쿠폰 (Field9) — integer
  • 후불결제 (Field11)

선불결제 (Payment_1)

  • userid (2) — STRING — 외래 키 → 사용자.userid — NOT NULL
  • name (Field4) — string — NOT NULL
  • money (Field2) — integer — 선불결제
  • created_time (Field) — timestamp — NOT NULL
  • updated_time (Field3) — timestamp

쿠폰 (Coupon)

  • userid (2) — STRING — 외래 키 → 사용자.userid — NOT NULL
  • serial_number (Key) — string — NOT NULL
  • money (Field) — integer
  • created_time (Field2) — timestamp — NOT NULL
  • updated_time (Field3) — timestamp — NOT NULL

후불결제 (Payment_2)

  • userid (2) — STRING — 외래 키 → 사용자.userid — NOT NULL
  • money_total (Field) — integer
  • created_time (Field2) — timestamp — NOT NULL
  • updated_time (Field3) — timestamp — NOT NULL
  • limit_time (Field4) — timestamp — NOT NULL — 기간 더하기