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