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