ButlerLee

Tables (7)

coupon

  • id — int — Primary key — NOT NULL
  • code — varchar(20)
  • name — varchar(100)
  • description — varchar(255)
  • available — tinyInt(1)
  • available_days — int
  • discount_type — varchar(50)
  • discount_amount — decimal
  • due_date — datetime
  • number_of_uses_initial — int
  • number_of_uses_used — int
  • create_date — datetime
  • modify_date — datetime

payment

  • id — int — Primary key — NOT NULL
  • payment_gateway — varchar(50)
  • reservation_id — int
  • reservation_no — varchar(50)
  • payment_key — varchar(100)
  • listing_id — int
  • order_name — varchar(100)
  • arrival_date — datetime
  • departure_date — datetime
  • easy_pay — varchar(30)
  • method — varchar(100)
  • total_amount — decimal
  • point_amount — decimal
  • payment_amount — decimal
  • canceled_amount — decimal
  • canceled_point — decimal
  • card_discount_amount — decimal
  • card_company — varchar(20)
  • card_number — varchar(25)
  • card_installment_months — int
  • card_approve_no — varchar(25)
  • card_type — varchar(20)
  • card_owner_type — varchar(20)
  • card_receipt_url — varchar(200)
  • card_is_insterest_free — tinyInt(1)
  • card_acquire_status — varchar(20)
  • request_date — datetime
  • approve_date — datetime
  • cancel_date — datetime
  • update_time — datetime
  • user_id — int

point

  • id — int — Primary key — NOT NULL
  • coupon_id — int — Foreign key → coupon.id — NOT NULL
  • Field

role

  • id — int — Primary key — NOT NULL
  • authority — varchar(255)
  • discription — varchar(255)

unpaid_reservation

  • id — int — Primary key — NOT NULL
  • reservation_id — int
  • limit_start_date — datetime
  • cancel_date — datetime

user

  • id — int — Primary key — NOT NULL
  • login_id — varchar(255)
  • available — tinyInt(1)
  • password_hash — binary(64)
  • password_salt — binary(128)
  • nic_name — varchar(255)
  • name — varchar(255)
  • phone — varchar(25)
  • email — varchar(255)
  • create_date — datetime
  • withraw_date — datetime
  • is_withraw — tinyInt(1)
  • modify_date — datetime

user_role

  • user_id — int — Foreign key → user.id — NOT NULL
  • role_id — int — Foreign key → role.id — NOT NULL