team.pretzel

Tables (10)

admin

  • admin_id — INTEGER
  • admin_name — VARCHAR(100) — NOT NULL
  • admin_password — VARCHAR(255) — NOT NULL

comment

  • comment_id — INTEGER
  • user_id — INTEGER
  • insurance_id — INTEGER
  • content — VARCHAR(255)

coupon

  • coupon_id — INTEGER
  • user_id — INTEGER — NOT NULL
  • coupon_date — DATE — NOT NULL
  • used — BOOLEAN

discounts

  • discount_id — INTEGER
  • user_id — INTEGER — NOT NULL
  • insurance_id — INTEGER — NOT NULL
  • detail — VARCHAR(255) — NOT NULL
  • discount_rate — DECIMAL(3,2)
  • discount_validate — DATE — NOT NULL

goal

  • goal_id — INTEGER
  • user_id — INTEGER
  • day_goal — INTEGER
  • week_goal — INTEGER
  • exchange — BOOLEAN

goal_result

  • result_id — INTEGER
  • goal_id — INTEGER
  • walking — INTEGER
  • attachment — VARCHAR(255)
  • achieve — BOOLEAN
  • achieve_date — DATE

insurance_plans

  • insurance_id — INTEGER
  • insurance_type — VARCHAR(50) — NOT NULL
  • admin_in — INTEGER
  • premium — INTEGER — NOT NULL
  • detail — VARCHAR(50)
  • validity — INTEGER

notice

  • notice_id — INTEGER
  • admin_id — INTEGER
  • importance — INTEGER
  • content — TEXT — NOT NULL
  • reg_date — DATE — NOT NULL

payments

  • payment_id — INTEGER
  • user_id — INTEGER — NOT NULL
  • insurance_id — INTEGER — NOT NULL
  • amount — DECIMAL(10,2) — NOT NULL
  • payment_date — DATE — NOT NULL
  • refund — INTEGER — NOT NULL

users

  • user_id — INTEGER
  • user_loginid — VARCHAR(50) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • username — VARCHAR(50) — NOT NULL
  • email — VARCHAR(100) — NOT NULL
  • birth_date — DATE
  • gender — ENUM('M', 'F')
  • available — INTEGER