user_table
Tables (4)
agreement_info
- id — serial
- member_id — int — NOT NULL
- prescription_agreement — boolean — NOT NULL
- terms_of_service_agreement — boolean — NOT NULL
- agreement_date — date — NOT NULL
- push_notification_agreement — boolean — NOT NULL
members
- id — serial
- phone_number — varchar(11) — NOT NULL
- nickname — varchar(8) — NOT NULL
- profile_image — bytea — NOT NULL
- portal_authentication — boolean — NOT NULL
- portal_id — varchar(100) — NOT NULL
- portal_pw — varchar(100) — NOT NULL
- name — varchar(100) — NOT NULL
- birthdate — date — NOT NULL
- status — varchar(10) — NOT NULL
- entrance_year — int — NOT NULL
- department — varchar(100) — NOT NULL
- serial_number — int — NOT NULL
- state — varchar(10) — NOT NULL
school_info
- id — serial
- member_id — int — NOT NULL
- portal_id — varchar(100) — NOT NULL
- portal_pw — varchar(100) — NOT NULL
- name — varchar(100) — NOT NULL
- birthdate — date — NOT NULL
- status — varchar(10) — NOT NULL
- entrance_year — int — NOT NULL
- department — varchar(100) — NOT NULL
- serial_number — int — NOT NULL
- state — varchar(10) — NOT NULL
service_log
- id — serial
- member_id — int — NOT NULL
- registration_date — date — NOT NULL
- last_access_date — date — NOT NULL
- last_nickname_change_date — date — NOT NULL