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